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

8 votes175 views1 answer
Oracle search code in packages
SQL
1 vote96 views1 answer
Select from one table where not on the other
SQL
0 vote94 views1 answer
Metada in sql
SQL
15 votes244 views2 answers
How to sort names in alphabetical order in sql
SQL
1 vote107 views1 answer
Mysql find most common value
SQL
0 vote102 views1 answer
Mysql update sum same table
SQL
3 votes91 views1 answer
Oracle nextval
SQL
38 votes164 views4 answers
Count sql
SQL
0 vote101 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
2 votes110 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL