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 vote122 views1 answer
Sql min
SQL
0 vote130 views1 answer
Oracle allow space to user
SQL
0 vote132 views1 answer
Sql delimiter to columns
SQL
0 vote147 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote129 views1 answer
Get last three characters in mysql column
SQL
1 vote123 views1 answer
Psql lst trigger
SQL
0 vote130 views1 answer
How to remove default in mysql
SQL
0 vote126 views1 answer
Apt install sql server
SQL
44 votes202 views6 answers
Rename command in sql
SQL
0 vote123 views1 answer
Comparing with today and yesterday record in sql query
SQL