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

12 votes151 views1 answer
Script to add new column in table sql
SQL
5 votes192 views3 answers
Create function in postgresql
SQL
0 vote146 views1 answer
Microsoft word insert sql code
SQL
-1 vote146 views1 answer
Auto increment psql not primary key
SQL
0 vote139 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
2 votes155 views1 answer
Docker run postgres locally
SQL
1 vote100 views1 answer
Alter user mysql native password
SQL
0 vote157 views1 answer
Query to remove duplicate rows from a table
SQL
4 votes135 views3 answers
Oracle sql first day of quarter
SQL
13 votes155 views2 answers
Sql join 3 tables
SQL