MySQL query for adding one or more elements to comma separated string list

Question

I have MySQL table with column name 'subscriptions'. It contains some comma separated values.

Id  Subscription
22  mobiles,watches,Tv,laptops

I need to add tablets, keyboards to this subscription field ie, my table should look like this

Id  Subscription
22  mobiles,watches,Tv,laptops,tablets,keyboards

Any special MySQL queries for this?

What is the function of the HTML here? I don't understand. If you are just using HTML for presentation in the question, don't put it in a snippet. — Anders
– Anders, Commented Sep 24, 2015 at 8:06
Storing comma-separated values in a database is most often a sign for a bad database design. As long as its just a string for you and you are not interested in its substrings, fine. But once you don't treat this as a mere thing but do string manipulations on it (which is exactly what you are doing here!) it is very likely you chose a bad design. — Thorsten Kettner
– Thorsten Kettner, Commented Sep 24, 2015 at 8:35

ManiMuthuPandi · Accepted Answer · 2015-09-24 08:05:28Z

2

Use this update query

update YourTableName set subscriptions=concat(subscriptions,',tablets,keyboards') 
where id='22'

answered Sep 24, 2015 at 8:05

ManiMuthuPandi

1,6042 gold badges29 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Correct; it is that simple. Strange that the OP didn't find this solution themselves.