mysql-replace函数

查找sensor_number中含有空格的所有结果

select * from t_sensor_info where sensor_number like '% '

使用replace函数将空格替换成null

UPDATE t_sensor_info si SET si.sensor_number=REPLACE(si.sensor_number, ' ', '');