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 vote353 views1 answer
Sqlcmd no headers
SQL
7 votes354 views1 answer
Mysql iif
SQL
1 vote347 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote345 views1 answer
Implicit inner join table alias
SQL
0 vote333 views1 answer
Sqlalchemy query join many to many
SQL
0 vote356 views1 answer
On delete set default
SQL
4 votes352 views2 answers
Oracle default date format
SQL
0 vote336 views2 answers
Sql server select first day of previous year
SQL
9 votes369 views1 answer
Alter table column change data type to text mysql
SQL
0 vote323 views2 answers
Mysql multiply
SQL