MySQL – Select where field contents are in UPPERCASE

How to select rows from a table where a field contents are all in UPPERCASE

SELECT

    fieldName

FROM

   tableName

WHERE

   fieldName REGEXP BINARY ‘^[A-Z]+$’