As we know that MySQL is not case-sensitive while comparing characters but it can be changed i.e. MySQL can perform case-sensitive string comparison if we will use BINARY keyword before the expression. Actually, BINARY keyword instructs MySQL to compare the characters in the string using their underlying ASCII values rather than just their letters. It can be illustrated with the following example from table ‘Employee’ having the following data −
mysql> Select * from Employee; +----+--------+--------+ | ID | Name | Salary | +----+--------+--------+ | 1 | Gaurav | 50000 | | 2 | Rahul | 20000 | | 3 | Advik | 25000 | | 4 | Aarav | 65000 | | 5 | Ram | 20000 | | 6 | Mohan | 30000 | | 7 | Aryan | NULL | | 8 | Vinay | NULL | +----+--------+--------+ 8 rows in set (0.09 sec)
下面的查询将使用BINARY关键字来强制MySQL执行区分大小写的字符串比较。
mysql> Select * from Employee WHERE BINARY Name IN ('Gaurav','RAM'); +----+--------+--------+ | ID | Name | Salary | +----+--------+--------+ | 1 | Gaurav | 50000 | +----+--------+--------+ 1 row in set (0.00 sec)
以上就是MySQL如何进行区分大小写的字符串比较?的详细内容,更多请关注php中文网其它相关文章!
已抢65582个
抢已抢30300个
抢已抢16676个
抢已抢8447个
抢已抢10929个
抢已抢22322个
抢