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 vote196 views2 answers
Pl sql auto increment
SQL
4 votes208 views1 answer
Sql data types
SQL
10 votes169 views2 answers
Sql where clause multiple values
SQL
0 vote191 views1 answer
Exec procedure oracle
SQL
0 vote239 views1 answer
How to print some string in mysql
SQL
0 vote193 views2 answers
Database owner can't create new tables postgres
SQL
11 votes196 views1 answer
Get ddl materialized view oracle
SQL
2 votes216 views1 answer
Sql find not in list
SQL
2 votes211 views1 answer
Add new column not null sql server
SQL
0 vote246 views1 answer
Datagrip exec
SQL