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 vote199 views1 answer
SQL check if record exist
SQL
0 vote162 views1 answer
View acl table oracle
SQL
0 vote172 views1 answer
Mysql set column equal to another automatic
SQL
1 vote197 views1 answer
How to set up a trigger in sql
SQL
4 votes122 views1 answer
And or sql order of operations
SQL
1 vote168 views2 answers
Mysql current user
SQL
5 votes176 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
5 votes161 views2 answers
Sql conn
SQL
0 vote154 views1 answer
Show table structure mysql console
SQL
0 vote164 views1 answer
Check duplicate values plsql
SQL