Mysql去掉字段前中后的空格

admin

Mysql去掉字段前中后的空格，以帝国CMS为例，运行Mysql语言

1. 左边
   
2. UPDATE fenlei_shipin SET type_name=LTRIM(type_name)
   
3. 
   
4. 全部
   
5. UPDATE fenlei_shipin SET type_name=TRIM(type_name)
   
6. 
   
7. 右边
   
8. UPDATE fenlei_shipin SET type_name=RTRIM(type_name)

复制代码

或者：去掉SS库里所有title左边（前面）的空格

1. UPDATE phome_ecms_SS SET title=LTRIM(title)

复制代码

更新截取数值

1. UPDATE book_info SET file_path = (SELECT SUBSTRING(file_path, 1, LENGTH(file_path)-4)) WHERE type =2 AND file_path LIKE ‘%.mp4%’
   
2. UPDATE book_info SET file_path = CONCAT(file_path,".pdf") WHERE id = 803
   

复制代码

去除\r\n
查询\r\n

1. SELECT *FROM data_tree WHERE name LIKE ‘%\r\n%’;
   

复制代码

去掉\r\n

1. UPDATE data_tree SET name = REPLACE( REPLACE( name , CHAR( 10 ) , ‘’ ) , CHAR( 13 ) , ‘’ )

复制代码