MySQL 如何使用mysql替换将所有双引号替换为单引号？

How to replace all double quotes to single quotes using mysql replace?

提问by DEVOPS

I need to replace all double quotes to single quotes using mysql query.

我需要使用 mysql 查询将所有双引号替换为单引号。

How can I do that. My sql should be in double quotes.

我怎样才能做到这一点。我的 sql 应该是双引号。

mysql="select replace(text,'\"',''') from mytable"

throwing error. How can I escape that single quotes inside query?

抛出错误。如何在查询中转义单引号？

回答by Shakti Singh

Try this one

试试这个

 $mysql="select replace(text,'\"',\"'\") from mytable";

Then the query will become

然后查询将变成

select replace(text,'"',"'") from mytable

at the Mysql end.

在 Mysql 端。

回答by jensgram

You need to escape the single quote 'too (see table 8.1):

你也需要转义单引号'（见表 8.1）：

mysql="select replace(text,'\"','\'') from mytable"

Thus, the string sent to MySQL will read:

因此，发送到 MySQL 的字符串将显示为：

select replace(text,'"','\'') from mytable