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 vote263 views2 answers
Update all linkedserver tables with openquery on db
SQL
0 vote295 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote288 views1 answer
No query unable to fetch row sqlite
SQL
1 vote269 views1 answer
Mariadb alter user host
SQL
0 vote261 views1 answer
Truncate table sql server foreign key
SQL
-1 vote274 views1 answer
How to switch user in mysql
SQL
3 votes309 views5 answers
No module named 'MySQLdb'
SQL
0 vote271 views1 answer
Insert array into mysql column
SQL
0 vote261 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
1 vote439 views3 answers
Create table from existing table in sql
SQL