Removing slashes from the database
| From: | Ron Piggott | Date: | Wed, 03 Jun 2015 02:50:11 +0000 |
| Subject: | Removing slashes from the database | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-49030@lists.php.net to get a copy of this message | ||
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