好的?它的工作方式与预期一致。

mysql> CREATE TABLE MyTbl (id INT, title TEXT);
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO MyTbl VALUES(1,'apple "apple');
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM MyTbl;
+------+-------------+
| id   | title       |
+------+-------------+
|    1 | apple"apple |
+------+-------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM MyTbl WHERE title = 'apple "apple';
+------+-------------+
| id   | title       |
+------+-------------+
|    1 | apple"apple |
+------+-------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM MyTbl WHERE title like('apple "apple');
+------+-------------+
| id   | title       |
+------+-------------+
|    1 | apple"apple |
+------+-------------+
1 row in set (0.00 sec)

可能是和太空角色有关吧？

mysql> SELECT * FROM MyTbl WHERE title = 'apple"apple';
Empty set (0.00 sec)

mysql> SELECT * FROM MyTbl WHERE title = 'apple "apple';
+------+--------------+
| id   | title        |
+------+--------------+
|    1 | apple "apple |
+------+--------------+
1 row in set (0.00 sec)

运行这个命令怎么样？它给你的回报是什么？

mysql> SELECT @NO_BACKSLASH_ESCAPES;
+----------------------------------------------+
| @NO_BACKSLASH_ESCAPES                        |
+----------------------------------------------+
| NULL                                         |
+----------------------------------------------+
1 row in set (0.00 sec)