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

12 votes165 views2 answers
Update column data type postgres
SQL
20 votes113 views1 answer
Sql change column types
SQL
1 vote125 views1 answer
Connect to mysql database ubuntu
SQL
4 votes102 views1 answer
Mysql set max connections
SQL
0 vote109 views1 answer
Php mysqli install
SQL
7 votes127 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote142 views1 answer
C# sql transaction multiple connections
SQL
34 votes123 views6 answers
Install mysql client ubuntu
SQL
7 votes120 views5 answers
Max 3 salary in sql
SQL
0 vote121 views1 answer
Query to remove duplicate rows from a table
SQL