Removing slashes from the database

From: 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

« previous php.db (#49030) next »