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

Answers


MySQL REPLACE() replaces all the occurrences of a substring within a string.

Replace(column,'pillow','pillow case')

demo query :-

Select Replace(column,'pillow','pillow case') column
From table 

Need Your Help