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 vote259 views1 answer
Dnsmasq.conf location macos
SQL
3 votes259 views1 answer
Ms sql skip take
SQL
0 vote285 views1 answer
MySQL update with subquery
SQL
1 vote261 views1 answer
Sql Split string function
SQL
2 votes269 views1 answer
Postgresql left join distinct on
SQL
3 votes271 views1 answer
How to find names includes in sql
SQL
5 votes262 views1 answer
Oracle generate list of dates in between a date range
SQL
-2 votes257 views1 answer
Modify column name in tsql
SQL
3 votes248 views1 answer
Index using in query plsql
SQL
0 vote262 views7 answers
Les jointures sql server
SQL