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 vote317 views1 answer
Mysql drop multiple tables at once
SQL
0 vote338 views1 answer
Create database like
SQL
1 vote352 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote323 views1 answer
Power query case when
SQL
0 vote336 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
8 votes485 views4 answers
Convert date to dd/mm/yyyy sql
SQL
37 votes343 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
1 vote321 views1 answer
Type int in mysql maxlenght
SQL
0 vote286 views0 answer
SQL
0 vote332 views1 answer
Make a socket server to detect changes in mysql
SQL