MYSQL 多表更新 UPDATE SET like concat('%',abc,'%');

標籤：

SQL語句為：select * from table1 where  `text` like CONCAT(‘%‘,(select name from table2 where id =3),‘%‘);

UPDATE ecs_region a,nation b SET a.code = b.code where b.province like concat(‘%‘,a.region_name,‘%‘);

UPDATE ecs_region a,nation b SET a.code = b.code where b.city like concat(‘%‘,a.region_name,‘%‘);

UPDATE ecs_region a,nation b SET a.code = b.code where b.district like concat(‘%‘,a.region_name,‘%‘);

MYSQL 多表更新 UPDATE SET like concat('%',abc,'%');