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 vote113 views1 answer
How to order result of subquery in select
SQL
0 vote121 views1 answer
Sql select first and last record of each group
SQL
4 votes124 views2 answers
Postgres update single column
SQL
10 votes113 views3 answers
Sql limit results
SQL
1 vote130 views1 answer
Oracle select first row order by
SQL
0 vote125 views1 answer
View to table
SQL
0 vote125 views1 answer
Sql remove first character from string
SQL
0 vote121 views1 answer
Flask sqlalchemy decimal
SQL
0 vote129 views1 answer
Sql select where more than one record exists
SQL
0 vote122 views1 answer
Check duplicate values plsql
SQL