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 vote228 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote241 views1 answer
Can't connect to postgresql mac os
SQL
0 vote255 views1 answer
Proc sql not in working
SQL
17 votes232 views5 answers
Order by sql
SQL
11 votes247 views1 answer
Mysql order by two columns priority
SQL
0 vote203 views1 answer
Big query add table rows to another table
SQL
-1 vote268 views1 answer
How to Activate the database
SQL
0 vote247 views1 answer
Excel export from sql using python
SQL
4 votes234 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote222 views1 answer
Sql cross apply vs join
SQL