Re: Removing slashes from the database

On Tue, Jun 2, 2015 at 10:50 PM, Ron Piggott <[email protected]
> 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?