Select ALL fields that contains only UPPERCASE let

Question

How do you select a field that contains only uppercase character in mysql or a field that doesn't contain any lower case character?

Answer 1

SELECT * FROM table1 WHERE (columnname COLLATE latin1_bin )=UPPER(depart);

Answer 2

SELECT column_name FROM table WHERE column_name REGEXP BINARY '^[A-Z]+$'