I have a column containing list of streets. I need to replace 'eyeglasses' with 'glasses'. The replacement can be made in the current column or in a new column with the address in the required format. The following is the sample data. 'Column 1' contains the data in current format. 'Column 2' contains the data in the desired format.
Code:
Column 1 Column 2
cheap eyeglasses cheap glasses
sports sunglasses sports sunglasses
discount eyeglasses discount glasses
There are about 1000 products at
www.bestpriceglasses.com, if modify one by one, too much trouble. I think it is really a good idea if I can modify via MySQL command.