Mysql 字符串like比较 大小写忽略

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