数据
id value
1 aa<p>QL实木颗粒</p>
2 bb<p>QL实木颗粒</p>
3 cc<p>QL实木颗粒</p>
1.拼接字符串
##拼接字符串 update `z_biao` set `value` = CONCAT("前面添加字符串",`value`,"中间添加字符串", `value`, "后面添加字符串") where id = 1;
数据
id value
1 前面添加字符串aa<p>QL实木颗粒</p>中间添加字符串aa<p>QL实木颗粒</p>后面添加字符串
2 前面添加字符串bb<p>QL实木颗粒</p>中间添加字符串bb<p>QL实木颗粒</p>后面添加字符串
3 前面添加字符串cc<p>QL实木颗粒</p>中间添加字符串cc<p>QL实木颗粒</p>后面添加字符串
2.过滤字符串
update `z_biao` set `cont` = REPLACE(`value`,"<p>","") where id = 1;
id value
1 前面添加字符串aaQL实木颗粒</p>中间添加字符串aaQL实木颗粒</p>后面添加字符串
2 前面添加字符串bbQL实木颗粒</p>中间添加字符串bbQL实木颗粒</p>后面添加字符串
3 前面添加字符串ccQL实木颗粒</p>中间添加字符串ccQL实木颗粒</p>后面添加字符串