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 vote216 views2 answers
Find Overlapping sql
SQL
0 vote216 views1 answer
Default column value in sql same as other column
SQL
0 vote246 views1 answer
Mysql insert into select transaction c#
SQL
0 vote231 views2 answers
How to use aggregate functions in sql
SQL
5 votes244 views1 answer
Get table columns from sql
SQL
0 vote258 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote230 views1 answer
Mysql grant user wildcard database
SQL
3 votes219 views1 answer
Oracle failed login attempts
SQL
0 vote238 views3 answers
Mysql regex replace
SQL
57 votes342 views6 answers
Sql alter table
SQL