My table had 'tags' field like this:
Tags
tag1,tag2,tag3
How to remove ',tag2' including comma using mysql query.
See Question&Answers more detail:osMy table had 'tags' field like this:
tag1,tag2,tag3
How to remove ',tag2' including comma using mysql query.
See Question&Answers more detail:osI 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.