mysql字符串之大小写匹配查询

发布2018-01-06浏览10228次

详情内容

直接看：

mysql> create table test (name varchar(64));
Query OK, 0 rows affected (0.04 sec)

mysql> insert into test set name = 'taoge';
Query OK, 1 row affected (0.03 sec)

mysql> select * from test;
+-------+
| name  |
+-------+
| taoge |
+-------+
1 row in set (0.00 sec)

mysql> select * from test where name = 'TAOGE';
+-------+
| name  |
+-------+
| taoge |
+-------+
1 row in set (0.00 sec)

mysql> select * from test where name = 'taoge';
+-------+
| name  |
+-------+
| taoge |
+-------+
1 row in set (0.00 sec)

mysql> select * from test where binary name = 'TAOGE';
Empty set (0.00 sec)

mysql> select * from test where binary name = 'taoge';
+-------+
| name  |
+-------+
| taoge |
+-------+
1 row in set (0.00 sec)

mysql>