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;