mysql - 如何通过sql替换数据库中的撇号

Question

我正在尝试将 "?t" 字符串替换为 "'t"(撇号 t)

我在phpMyAdmin中输入这个命令

UPDATE "myTable"
SET "myColumn" = REPLACE ("myColumn", "\?t", "\'t")

如 How can I use mySQL replace() to replace strings in multiple records? 中的建议)

我收到这个错误

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near UPDATE "myTable"
SET "myColumn" = REPLACE ("myColumn", "\?t", "\'t") at line 1

我的命令有什么问题？

谢谢

Answer 1

不要引用表名或列名。如果您需要转义它们，请使用反引号

UPDATE `myTable`
SET `myColumn` = REPLACE (`myColumn`, '?t', '\'t')