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 vote309 views1 answer
Dns slave zone convert
SQL
0 vote299 views1 answer
Downgrading sql localdb visual studio
SQL
1 vote325 views2 answers
How to search date in sql query
SQL
0 vote351 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
2 votes341 views2 answers
Mysql add hours to time field
SQL
14 votes400 views1 answer
How to export db from mysql
SQL
4 votes321 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote318 views1 answer
Sum value by month sql
SQL
1 vote334 views1 answer
Select 2 rows in sql
SQL
0 vote326 views1 answer
Sql server concat null
SQL