update 字符串拼接

UPDATE store SET food_ordering =1,self_pickup_remark = CONCAT('self pick up notes:',store_code,short_name) WHERE merchant_id = "360087641000000807" 
AND (id > 23500 AND id <= 23510)
OR (id > 23600 AND id <= 23610)
OR (id > 23700 AND id <= 23710)
OR (id > 23800 AND id <= 23810)
ORDER BY id ASC;

 

posted @ 2020-06-17 11:41  pandaly  阅读(1507)  评论(0编辑  收藏  举报