※ 引述《jami520 (我的生命因你而發光)》之銘言:
: 我知道查詢可以在欄位前加上BINARY來做查詢區分
: 但使用Group by BINARY XXX 似乎大小寫無法區分開來呢
: 不知道有什麼解決方法嗎? 謝謝
如果是 case (in)sensitive,你要的功能是 COLLATE:
mysql> SELECT realname FROM user GROUP BY realname;
+----------+
| realname |
+----------+
| NULL |
| CASE |
+----------+
2 rows in set (0.09 sec)
mysql> SELECT realname FROM user GROUP BY realname COLLATE latin1_general_cs;
+----------+
| realname |
+----------+
| NULL |
| CASE |
| case |
+----------+
3 rows in set (0.10 sec)
Ref:
http://dev.mysql.com/doc/refman/5.5/en/charset-collate.html
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 210.242.135.97