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

1 vote296 views1 answer
Adding a check statement in sql
SQL
5 votes182 views2 answers
Postgre insert select
SQL
0 vote186 views1 answer
Mysql drop multiple tables at once
SQL
0 vote176 views1 answer
Mysql show category once count how many products
SQL
0 vote178 views1 answer
Sql server cannot create database diagram
SQL
0 vote152 views1 answer
Mysql select top 2
SQL
0 vote197 views1 answer
Psql attribute cannot login
SQL
0 vote198 views1 answer
Postgres reorder columns
SQL
8 votes215 views3 answers
Find table for column name in sql
SQL
11 votes287 views2 answers
Sql between date range
SQL