SQL Query for Find and Replace is not working
i want to run a find and replace query in my sql database using php my admin. The problem is that in the text that i want to find and replace are some " characters and this causes problems when i run the command...
i want to search for align="right"> and replace it by align="left">
i did run this command but its not working:
UPDATE `ps_product_lang` SET `description` = replace(`description`,"align="right">","align="lef t">");
So im wondering how should this query look like as there are " characters? How is it possible to search for even much longer text and replace it using sql queries?