590
社区成员
发帖
与我相关
我的任务
分享
update y_xinxi
set tellinfo=concat('<div class=''aa''><img src=''images/1.jpg''/><span>张三 2018-01-03 14:11:03</span><p>张三三三三</p></div>',tellinfo)
where locate('已沟通',quality)>0
update y_xinxi set tellinfo = concat(tellinfo,'<div class=''aa''><img src=''images/1.jpg''/><span>张三 2018-01-03 14:11:03</span><p>张三三三三</p></div>') where quality like '%已沟通%'
update y_xinxi set tellinfo = concat(tellinfo,'<div class=''aa''><img src=''images/1.jpg''/><span>张三 2018-01-03 14:11:03</span><p>张三三三三</p></div>')
create table y_xinxi(
tellinfo varchar(500)
);
insert into y_xinxi
select 'abcdefg';
update y_xinxi
set tellinfo=concat('<div class=''aa''><img src=''images/1.jpg''/><span>张三 2018-01-03 14:11:03</span><p>张三三三三</p></div>',tellinfo)
AND quality like '%已沟通%'
用and链接不用where