如何查找具有小写字符串的行MySQL查询

试试下面的方法。这将为您提供所有带有小写字符串的列条目-

select 'column' from 'table' where 'column' regexp binary '^[a-z]*$'; 

latin1_swedish_ci

SELECT * FROM `table_name`  WHERE  UPPER(column_name) != column_name
COLLATE latin1_swedish_ci

或

SELECT * FROM `table_name` 
WHERE UPPER([column_name]) COLLATE latin1_swedish_ci !=[column_name]

应该首先检查各自数据库和列的默认排序规则…并将默认排序规则与查询表达式一起传递