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 vote173 views1 answer
Psql get table data types
SQL
1 vote265 views1 answer
Sql server delete top 1000
SQL
0 vote176 views1 answer
Setval in postgres
SQL
0 vote171 views1 answer
Split string by comma in sql server
SQL
0 vote158 views5 answers
Sql table intermédiaire
SQL
0 vote188 views1 answer
Least spark sql
SQL
2 votes174 views1 answer
Columns Present in a table
SQL
1 vote171 views1 answer
Mysql date diff in seconds
SQL
2 votes191 views1 answer
Oracle sql merge
SQL
5 votes239 views1 answer
Mysql last day of next month
SQL