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 vote84 views2 answers
Denormalization in sql
SQL
0 vote128 views1 answer
How to install postgresql on wsl
SQL
16 votes134 views2 answers
Oracle ddl
SQL
0 vote159 views1 answer
Sql order by number not ordered
SQL
0 vote124 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote236 views1 answer
Sqlite woth cmake
SQL
1 vote136 views2 answers
How to drop a unique constraint in sql
SQL
4 votes126 views2 answers
Mysql select where starts with
SQL
0 vote139 views1 answer
Into operator in sql
SQL
0 vote136 views3 answers
Sql parenthetical expression examples
SQL