mysql字串之大小寫匹配查詢

        直接看：

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>