Re: Removing slashes from the database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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
> 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?

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux