how to find and replace a word in a mysql column?

[Maribel]

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.

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.

[New Britain]

This query works for this:

UPDATE table SET column = REPLACE(column, 'eyeglasses', 'glasses');