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 vote203 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote117 views1 answer
Pl sql round
SQL
0 vote127 views1 answer
How to select even id in sql
SQL
5 votes112 views1 answer
Alter table add comment oracle
SQL
0 vote118 views1 answer
Mysql, how to query the table comments?
SQL
0 vote111 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote124 views1 answer
Sql server isnull function nor working count
SQL
-1 vote124 views3 answers
Update mongodb version ubuntu
SQL
0 vote127 views2 answers
Dumping sql table
SQL
0 vote114 views1 answer
Get current date data in mysql
SQL