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

5 votes334 views1 answer
AND OR NOT operators sql
SQL
0 vote301 views1 answer
Implicit inner join table alias with id values
SQL
18 votes267 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote314 views2 answers
Sql join on comma separated field
SQL
2 votes337 views3 answers
Mysql pass command from command line
SQL
0 vote306 views1 answer
Sql grant select only
SQL
4 votes379 views2 answers
Sql display today's date
SQL
0 vote333 views1 answer
Generate random & unique mysql string
SQL
2 votes299 views1 answer
How to search table name in stored procedure in sql server
SQL
-1 vote336 views3 answers
MySQL shutdown unexpectedly
SQL