mysql 通用匹配符转义,MySQL转义符问题

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.

Ex :

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

Empty set (0.00 sec)

SELECT * FROM mytable WHERE data LIKE 'd\\%';

Empty set (0.00 sec)

解决方案

Use triple slash:

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