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 vote191 views1 answer
Mysql where sum > 0
SQL
5 votes153 views5 answers
Sqlite install python
SQL
1 vote191 views1 answer
Mysql current running queries
SQL
23 votes162 views4 answers
How to uninstall postgresql in ubuntu
SQL
5 votes233 views1 answer
Oracle source query
SQL
1 vote166 views1 answer
Oracle create program if no exists
SQL
22 votes144 views2 answers
Mysql show all tables
SQL
0 vote144 views1 answer
Mysql percentage of total
SQL
0 vote184 views1 answer
Finding leap year in sql
SQL
0 vote160 views1 answer
Insert array into mysql column
SQL