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