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;