Removing slashes from the database
[email protected] (Ron Piggott) Tue, 02 Jun 2015 22:50:11 -0400
| Newsgroups | php.db |
|---|---|
| Organization | Acts Ministries Christian Evangelism |
| Message-ID | <[email protected]> |
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