sqlite, how replace a value from CSV saved in a column

Question

I have a table in my android app with a column named tags, this column can contain one or multiple comma separated values, for example : test1,test,test2 now I want to rename one of these values in entire table, I have the following query : update mytable set tags = replace (tags, ',test,',',XXX,') // rename test with XXX where tags like '%,test,%' this works fine as far as the value is in between commas. How can I achieve this for the situation where my value is at the start or end of the csv or is the only value in csv. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

You need to append commas at the start and at the end of the column and operate on that: update mytable set tags = trim(replace(',' || tags || ',', ',test,', ',XXX,'), ',') where ',' || tags || ',' like '%,test,%'; See the demo