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 vote147 views2 answers
Sql having multiple conditions
SQL
2 votes169 views1 answer
Sql update \
SQL
4 votes167 views1 answer
For loop postgresql
SQL
-1 vote156 views3 answers
My sql alter table
SQL
0 vote203 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
13 votes203 views6 answers
Mysql remove duplicates
SQL
0 vote224 views1 answer
Sql if clause within where clause
SQL
1 vote150 views1 answer
Convert rows to string sql server
SQL
0 vote156 views1 answer
Postgresql if else endif
SQL
12 votes208 views2 answers
Update column data type postgres
SQL