php - Mysql remove the specific word in comma seperated string

Question

My table had 'tags' field like this:

Tags

tag1,tag2,tag3

How to remove ',tag2' including comma using mysql query.

Answer 1

I think the best answer to such issue is on the below link The best way to remove value from SET field?

query should be like this which covers the ,value or value, or only value in the comma separated column

UPDATE yourtable
SET
  categories =
    TRIM(BOTH ',' FROM REPLACE(CONCAT(',', col, ','), ',2,', ','))
WHERE
  FIND_IN_SET('2', categories)

Here you can have your condition in where clause. for more details refer above link.