Finding all caps in columns?

Question

When working with MySQL, how can I fetch all rows where the name column is all uppercase?

Since equality is case insensitive, I'm not quite sure how to do this.

Answer 1

If your column collation is case insensitive, you can override it in your query:

SELECT * FROM my_table WHERE my_column COLLATE latin1_bin = UPPER(my_column);

COLLATE clause syntax.

Answer 2

SELECT * FROM my_table REGEXP '^[[:upper:]]+$';