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

3 votes334 views3 answers
Into in sql
SQL
3 votes393 views2 answers
Savepoint in sql
SQL
1 vote356 views1 answer
Sql dcl
SQL
5 votes355 views1 answer
Mysql last day of next month
SQL
14 votes391 views4 answers
Sql compiler
SQL
0 vote358 views1 answer
SQL Where-Klausel
SQL
0 vote397 views1 answer
Sql check if field is not null
SQL
0 vote309 views1 answer
Get number of table colums in sql query
SQL
0 vote359 views1 answer
Oracle table privileges
SQL
0 vote284 views1 answer
Check if has alpha characters sql
SQL