Mysql 字符串like比较 大小写忽略
在使用mysql 5.6.36时,有一个用例说明了大小写忽略的匹配。记得当时只是写了like进行mysql的匹配,应该做不了case insensitive的。
但是事实的确是,在官网上也有说明:
除非设置了特别的比较方法或者是一个二进制的string
The following two statements illustrate that string comparisons are not case sensitive unless >one of the operands is a case sensitive (uses a case-sensitive collation or is a binary >string):
mysql> SELECT ‘abc’ LIKE ‘ABC’;
-> 1
mysql> SELECT ‘abc’ LIKE _latin1 ‘ABC’ COLLATE latin1_general_cs;
-> 0
mysql> SELECT ‘abc’ LIKE _latin1 ‘ABC’ COLLATE latin1_bin;
-> 0
mysql> SELECT ‘abc’ LIKE BINARY ‘ABC’;
-> 0