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 vote321 views1 answer
Basic structure of sql expression having clause
SQL
0 vote315 views1 answer
Count database access django
SQL
5 votes329 views1 answer
Purge undo tablespace usage
SQL
1 vote308 views2 answers
Install mysqldump ubuntu
SQL
0 vote313 views1 answer
Mysql multiple primary keys
SQL
0 vote314 views1 answer
Mysql in clausule string array
SQL
0 vote300 views1 answer
Select all tables linked server sql
SQL
0 vote318 views3 answers
Select random sql
SQL
0 vote265 views1 answer
Print sum of values sql
SQL
0 vote310 views1 answer
Mysql to get column name in database
SQL