How to find all upper case strings in a MySQL table?

case-sensitive, mysql, string, uppercase

Solution

If your collation is case insensitive then you need to use a `BINARY` comparison:

SELECT *
FROM yourtable
WHERE Name = BINARY UPPER(Name)

See it working online: sqlfiddle

Problem

I initially thought this is trivial. Then thought 'binary' might do it. I am unsure at this point. ``` Name ---- John MARY Kin TED ``` I would like to query just MARY and TED which are in all upper case. How would I query this?

Original source