Mysql add string to multiple-columns
I have a database of some products. A column is name of products. In this column i want to add a word in some of them which include specific word. Let me give an example:
1 column new pillow 2 column new carpet, I want to add the word case only after the word pillow like this new pillow case and the 2. column new carpet must be stay same new carpet
MySQL REPLACE() replaces all the occurrences of a substring within a string.
demo query :-
Select Replace(column,'pillow','pillow case') column From table