MySQL如何进行区分大小写的字符串比较？

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 −,登录后复制,下面的查询将使用BINARY关键字来强制MySQL执行区分大小写的字符串比较。,登录后复制,以上就是MySQL如何进行区分大小写的字符串比较？的详细内容，更多请关注www.92cms.cn其它相关文章！