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 vote194 views1 answer
Dump only schema
SQL
0 vote220 views1 answer
Calculate age in sql
SQL
2 votes237 views1 answer
Find column in all stored procedures sql server
SQL
0 vote224 views1 answer
Insert value in identity
SQL
1 vote213 views1 answer
Get create table query existing table mysql
SQL
0 vote216 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
2 votes210 views1 answer
SELECT INTO
SQL
2 votes195 views1 answer
Create table with primary key
SQL
2 votes212 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote204 views1 answer
Storing RGBA in mysql db
SQL