mysql finf columns contaning uppercase letters code example
Example: 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)
;