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 votes141 views1 answer
Mysql count lines
SQL
20 votes135 views2 answers
Counting in sql
SQL
2 votes184 views3 answers
Mysql kill
SQL
0 vote145 views1 answer
Mysql Selected All Duplicate Rows
SQL
1 vote138 views1 answer
Sql where last 12 months
SQL
0 vote148 views1 answer
Get schema of table sql
SQL
0 vote158 views1 answer
Space not removing from column in sql
SQL
3 votes140 views1 answer
Two select sql
SQL
-1 vote143 views1 answer
What is in operator
SQL
1 vote153 views1 answer
Postgres see sequence current state
SQL