商圈下删除店铺(2)
📅 2026/7/2 18:46:01
👁️ 阅读次数
📝 编程学习
-- 删除所有商圈中指定的店铺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', ',%');
编程学习
技术分享
实战经验