Select ALL fields that contains only UPPERCASE letters

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?

user_1134321 · Answer

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

user_95733 · Answer

Found this in the comments - it deserves a post of its own:

SELECT * FROM mytable WHERE BINARY mycolumn = BINARY UPPER(mycolumn);

The problem with WHERE UPPER(mycolumn) = mycolumn is the collation, and it depends on your table what you can use there.