I am working through the process of removing \'s from the database. I am trying to get this query using a variable starting with "<<<"

$query1  =<<<EOF
UPDATE `TABLE_NAME` SET `COLUMN_NAME` = 
REPLACE(REPLACE(REPLACE(`COLUMN_NAME`,'\\\'','\''),'\\\"','"'),'\\\\','\\');
EOF;

But when I go to execute the query I am getting the error:

|#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\''),'\\"','"'),'\\','\')' at line 1 |

Could someone help me know what \ and ' should be part of this query so it will execute correctly --- only removing \'s from the database table text columns?

Thank you.

Ron

Reply via email to