UPDATE sys_user
SET read_notice = CONCAT(read_notice, “4,” ),
unread_notice = REPLACE (unread_notice, ‘4,’, ‘’ )
WHERE
user_id = 1;
SELECT CONCAT_WS(’,’,null,‘2’);
UPDATE sys_user
SET read_notice = CONCAT(read_notice, “4,” ),
unread_notice = REPLACE (unread_notice, ‘4,’, ‘’ )
WHERE
user_id = 1;
SELECT CONCAT_WS(’,’,null,‘2’);