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

2 votes411 views1 answer
Creating a view SQL
SQL
3 votes358 views2 answers
Oracle privileges users
SQL
0 vote342 views1 answer
Knex last insert id mysql
SQL
4 votes355 views2 answers
Mysql alter table set column unique
SQL
1 vote324 views1 answer
Stored procedure return value
SQL
1 vote348 views1 answer
Mysql remove last empty newline
SQL
3 votes353 views2 answers
To_char oracle
SQL
1 vote371 views1 answer
Insert value to new table by joining 2 different tables
SQL
4 votes355 views2 answers
Linq join
SQL
0 vote361 views1 answer
Sql where part of string match
SQL