复杂的sql语句

UPDATE mw_shop_setting a, mw_shop_setting_lock b
SET a.key_val = b.week_day
WHERE substr(a.key_name,19)=b.building_id
AND substr(key_name,1,18)='buliding_week_day_'
AND a.shop_id=28;