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

17 votes262 views4 answers
Mysql remove ubuntu
SQL
1 vote205 views1 answer
Create table variable in sql stored procedure
SQL
0 vote201 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote188 views1 answer
Mysql jdbc timezone
SQL
0 vote190 views1 answer
Doesn't have default value mysql
SQL
1 vote203 views1 answer
Mysql get max value and id
SQL
1 vote201 views1 answer
Update foreign key value in mysql
SQL
0 vote213 views1 answer
Mysql persistence.xml
SQL
0 vote190 views1 answer
Sql get user account
SQL
3 votes234 views4 answers
Mysql create table from select statement
SQL