商圈下删除店铺(2)
-- 删除所有商圈中指定的店铺ID
UPDATE business_circle
SET store_ids TRIM(BOTH , FROM REPLACE(CONCAT(,, store_ids, ,), CONCAT(,, 123, ,), ,)
)
WHERE store_ids IS NOT NULL AND store_ids ! AND CONCAT(,, store_ids, ,) LIKE CONCAT(%,, 123, ,%);
2026/7/2 18:36:14