Check out example codes for "replace content value from old to new sql". It will help you in understanding the concepts better.

Code Example 1

Update  tbl.Products
Set articlenumber = replace(articlenumber, 's401', 'I00010')

Learn ReactJs, React Native from akashmittal.com