Need help with a SQL command to find and replace one word in the products_description table, and set products_description to a new word, where products_description is this word..
I have the word hematite around 400 times in the product_description and want to change to magnatite
SET products_description = 'magnatite'
WHERE products_description = 'hematite';
- admin panel/ tools/ install sql patches
- I insert the following and get 1 processed but no change
- What is wrong...