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

2 votes218 views1 answer
Removing view
SQL
5 votes221 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
4 votes212 views1 answer
Mysql set max connections
SQL
2 votes226 views1 answer
Oracle convert run_duration to number
SQL
27 votes216 views6 answers
Set password mysql
SQL
1 vote210 views1 answer
Stop mysql server mac
SQL
1 vote202 views1 answer
Update from select join
SQL
15 votes215 views1 answer
Mysql int range
SQL
0 vote223 views1 answer
Declare date variable sql
SQL
0 vote254 views1 answer
Psql create usr
SQL