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 vote361 views1 answer
Sql server query database space available
SQL
32 votes385 views6 answers
Insert select
SQL
8 votes392 views1 answer
Oracle search stored procedures for text
SQL
1 vote387 views1 answer
Sql server select rows by distinct column
SQL
2 votes405 views1 answer
Where clause for child record apex
SQL
0 vote355 views1 answer
Multiple tricky query in sql server
SQL
0 vote374 views1 answer
Get all employee of salary if more than in sql
SQL
2 votes414 views2 answers
Set value to null sql
SQL
0 vote396 views1 answer
Oracle exchange subpartition
SQL
0 vote366 views1 answer
Java sql connection
SQL