-- 删除所有商圈中指定的店铺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, ,%);