拼接字符查询
select concat('11','22','33');
+------------------------+
| concat('11','22','33') |
+------------------------+
| 112233 |
+------------------------+
mysql 删除字段的值某个字符串
update 表 set ZD=replace(ZD,'123','') where ZD like '%123%'
拼接字符查询
select concat('11','22','33');
+------------------------+
| concat('11','22','33') |
+------------------------+
| 112233 |
+------------------------+
mysql 删除字段的值某个字符串
update 表 set ZD=replace(ZD,'123','') where ZD like '%123%'