Replacing a Range of Fields in MySQL

Replace a range of values in a single MySQL column with the following query:

Update [Table_Name]

Set [Column_Name] =  replace([Column_Name], ‘[String to Replace]’,'[New String]’)

Where id Between [someNumber] and [anotherNumber]

About Curious Minds
We are a web development firm in New York and Chicago, providing development resources and consulting for websites and mobile apps since 2004.