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

24 votes304 views4 answers
Delete db postgres
SQL
1 vote306 views1 answer
Declare table variable
SQL
0 vote319 views1 answer
Sql express database size limit
SQL
0 vote298 views1 answer
Create table with float datatype in sql server
SQL
1 vote315 views1 answer
Avg mysql
SQL
8 votes288 views1 answer
Database backup in mysql server recovery
SQL
4 votes278 views1 answer
Postgresql show current database
SQL
1 vote306 views2 answers
Find nth highest salary of an employee
SQL
9 votes303 views2 answers
Sql limit to 5 results
SQL
1 vote300 views1 answer
Drop table if exists oracle
SQL