Mysql check if lowercase

-- will detect all names that are not in uppercase
SELECT 
    name, UPPER(name) 
FROM table 
WHERE 
    BINARY name <> BINARY UPPER(name)
;

-- will detect all names that are not in lowrcase
SELECT 
    name, UPPER(name) 
FROM table 
WHERE 
    BINARY name <> BINARY LOWER(name)
;

Source: stackoverflow.com

Similar codes

0 vote145 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote140 views1 answer
Sql add calculated column
SQL
3 votes130 views1 answer
How to remove characters from string in mysql
SQL
3 votes136 views2 answers
Oracle sql drop sequence
SQL
-1 vote134 views3 answers
Compute age mysql
SQL
0 vote132 views1 answer
Dns slave zone convert
SQL
0 vote142 views1 answer
Where name ends in SQL
SQL
1 vote162 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote132 views1 answer
Postgresql update to unique
SQL
0 vote135 views1 answer
Top frequency in sql server
SQL