摘要:
下文讲述检索MySQL数据表中的反斜杠“\”的方法,如下所示:
实现思路:
在搜索数据表时,使用 LIKE ‘%\\\%’ 及可检索出数据表中数据带有反斜杠信息
(使用单个反斜杠就可以代表一个反斜杠输出)
mysql > create table `maomao365.com`
-> (keyId int,
-> info varchar(100));
mysql> insert into `maomao365.com` (keyId,info)values(1,'test\\\test');
Query OK, 1 row affected (0.00 sec)
mysql> insert into `maomao365.com` (keyId,info)values(2,'mysql\test');
Query OK, 1 row affected (0.00 sec)
mysql> select * from `maomao365.com`;
+-------+-----------+
| keyId | info |
+-------+-----------+
| 1 | test\ est |
| 2 | mysql est |
+-------+-----------+
2 rows in set (0.00 sec)
mysql> select * from `maomao365.com` where info like '%\\\%';
+-------+-----------+
| keyId | info |
+-------+-----------+
| 1 | test\ est |
+-------+-----------+
1 row in set (0.00 sec)