mysql check if lowercase

Solutions on MaxInterview for mysql check if lowercase by the best coders in the world

showing results for - "mysql check if lowercase"
Shana
07 Mar 2018
1-- will detect all names that are not in uppercase
2SELECT 
3    name, UPPER(name) 
4FROM table 
5WHERE 
6    BINARY name <> BINARY UPPER(name)
7;
8
9-- will detect all names that are not in lowrcase
10SELECT 
11    name, UPPER(name) 
12FROM table 
13WHERE 
14    BINARY name <> BINARY LOWER(name)
15;