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 vote269 views1 answer
Sql string function update replace
SQL
7 votes262 views1 answer
Mysql iif
SQL
3 votes252 views4 answers
Mysql decimal
SQL
0 vote257 views1 answer
Mysql select field if condition
SQL
18 votes217 views2 answers
How to get all the tables displayed in oracle
SQL
9 votes282 views3 answers
Sql delete where in
SQL
0 vote246 views1 answer
Order by with where clause in mysql
SQL
0 vote267 views1 answer
Call scalar valued function sql
SQL
1 vote247 views1 answer
Mysql Case sum
SQL
0 vote243 views1 answer
First mysql
SQL