How to update a value at a position inside a comma separated string mysql

Asked Feb 21 '19 at 04:04

Active Feb 21 '19 at 04:04

Viewed 18 times

I have a column with the following data 8,12,17,18.

I want to update a value at a particular position

For eg .I want to change 17 which comes at position 3 to 25. I want to change the values depending on its position inside the comma separated string.

asked Feb 21 '19 at 04:04

Aniket

you want to change CSV data using ... MySQL? – Book Of Zeus Feb 21 '19 at 04:06
I have a column named products in MySQL table so I have to update the value at a particular position of that column value – Aniket Feb 21 '19 at 04:12
maybe a redesign of your schema is in order ? either create a new table or maybe "SET" can help you -- https://dev.mysql.com/doc/refman/8.0/en/set.html – Book Of Zeus Feb 21 '19 at 04:13
Sounds Interesting,but redesigning won't Help as I have loads of data in my table.And also set datatype takes a maximum of 64 elements.But in my case I have more than 100 elements in a set. – Aniket Feb 21 '19 at 04:30
Then I recommend to use another table. I know at this point it might be painful, but on the long run, it will be better – Book Of Zeus Feb 21 '19 at 04:31
But what about having more than 64 elements in a set – Aniket Feb 21 '19 at 04:32
you can't, it's a limitation of MySQL – Book Of Zeus Feb 21 '19 at 04:34

0 Answers0