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

1 vote105 views1 answer
Enable mysql slow query log
SQL
2 votes154 views1 answer
Express api ith mysql data
SQL
0 vote170 views2 answers
Create-toys-table-with-toy_name-column
SQL
1 vote152 views1 answer
Oracle apex run 404
SQL
0 vote178 views1 answer
Convert multiple columns to ROws in sql server
SQL
10 votes182 views6 answers
Mysql set root password
SQL
1 vote149 views1 answer
Sometimes i cant edit sql developer
SQL
1 vote138 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote116 views1 answer
Mysql offset from bottom
SQL
7 votes144 views4 answers
What is my mysql version
SQL