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 vote216 views1 answer
Mysql select all and rename one
SQL
0 vote196 views1 answer
Load utilities in sql server
SQL
5 votes201 views3 answers
Mysql extract month from date
SQL
2 votes200 views1 answer
Add 2 hours to current time in MySQL
SQL
3 votes211 views2 answers
Wp do sql query from function
SQL
2 votes195 views2 answers
Select list is not in group by clause
SQL
5 votes195 views1 answer
Commentaire table oracle
SQL
1 vote177 views1 answer
Firebase bigquery cloud message
SQL
0 vote198 views2 answers
Postgres show current role
SQL
0 vote202 views1 answer
Select from column mysql
SQL