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

-1 vote193 views3 answers
Check table exist postgresql
SQL
9 votes242 views3 answers
Date format in sql
SQL
0 vote204 views2 answers
How to display enum value sql server
SQL
15 votes202 views2 answers
Select Options
SQL
1 vote197 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote166 views1 answer
Login phpmyadmin without password
SQL
0 vote228 views1 answer
MySQL import data from large CSV file
SQL
0 vote205 views1 answer
Hoq to import database source
SQL
-1 vote202 views1 answer
Mac mysql workbench console
SQL
16 votes268 views6 answers
Insert sql
SQL