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 vote292 views1 answer
Mysql export search results
SQL
0 vote315 views2 answers
Mysql show foreign keys
SQL
0 vote300 views1 answer
Mysql exception output
SQL
11 votes302 views3 answers
How to get last row of table in sql
SQL
0 vote313 views1 answer
Plsql check how much space all databases are consuming
SQL
3 votes313 views2 answers
How to force truncate a table in mysql
SQL
0 vote313 views1 answer
Hashpass
SQL
1 vote284 views1 answer
How to group by month using sql server
SQL
0 vote276 views1 answer
Sql database connectivity
SQL
7 votes271 views1 answer
Append column sql
SQL