MYSQL Multiple table updates update SET like concat ('% ', ABC, '% ');

The SQL statement is: 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 Multiple table updates update SET like concat ('% ', ABC, '% ');