On Tue, Jun 2, 2015 at 10:50 PM, Ron Piggott <ron.piggott@xxxxxxxxxxxxxxxxxx > wrote: > > 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 > When you say remove, as replace all occurrences with an empty string, or replace with a different character?
