更新行而不删除mysql中的先前值

Question

One of my table has a field user_ids and the value of the field like 2,3

group_id| user_ids  
--------|------------   
1       | 2,3  
--------|------------  
2       | 5,8

I want to update the field without deleting the current value. For ex. If I need to add 5 for group_id id 1, then 2,3 should be like 2,3,5

I m using this query:

UPDATE users_group SET user_ids = CONCAT( SUBSTRING( user_ids, 1, CHAR_LENGTH( user_ids ) -1 ) , ',5' ) WHERE group_id =1

But it is deleting previous value with comma.

group_id| user_ids  
--------|------------   
1       | ,5  
--------|------------  
2       | 5,8

can anyone suggest the right way for this?

Answer 1

update table1 set name = concat(name, ', ', 5) WHERE group_id =1