商圈下删除店铺(2)

📅 2026/7/2 18:46:01 👁️ 阅读次数 📝 编程学习
商圈下删除店铺(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', ',%');