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 votes182 views2 answers
Created at and updated at in mysql
SQL
1 vote168 views1 answer
How to delete record sql delphi
SQL
10 votes194 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote179 views1 answer
Pl sql constraint user function
SQL
0 vote194 views1 answer
Shortcut run sql pgadmin
SQL
1 vote168 views1 answer
Delete row mssql
SQL
0 vote231 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote193 views1 answer
Report in database
SQL
0 vote138 views2 answers
How to combine two sql queries in one result
SQL
0 vote178 views1 answer
Close sql query vb.net
SQL