mysql默认like忽略英文大小写。。。 SELECT * FROM TABLE_X WHERE COL LIKE BINARY '%ZTO%'; 转载于:https://www.cnblogs.com/voctrals/p/10723635.html