MySQL转义符问题 [英] MySQL Escape Character Issue

问题描述

当我尝试解决

While I was trying to solve This Question. I created the dummy records in a table

create table mytable(data CHAR(30));

INSERT INTO mytable VALUES('d\\one'),('d\\two'),('d\\three');

SELECT * FROM mytable;
+---------+
| data    |
+---------+
| d\one   |
| d\two   |
| d\three |
+---------+
3 rows in set (0.00 sec)

现在，当我选择记录时，我没有任何结果，我尝试了很多类似但没有运气的组合.

Now when i am selecting records, I am getting no result, I have tried many combination with like but no luck.

例如:

SELECT * FROM mytable WHERE data LIKE "d\\%";
Empty set (0.00 sec)


SELECT * FROM mytable WHERE data LIKE 'd\\%';
Empty set (0.00 sec)

推荐答案

使用三斜杠:

SELECT * FROM mytable WHERE data LIKE "d\\\%"

这篇关于MySQL转义符问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！