SQL command to find and replace a word in the products description?

[haredo]

Yellow1912,

Thanks for your time..
Was up working late on that little task.
Was close, but yet far from the theory.

The correct path with your help was:

UPDATE products_description SET products_description = REPLACE(products_description, 'hematite', 'magnatite');