Regex Ninja

Cari "nama" yang tidak diawali oleh huruf alfabet lowercase dan uppercase.

SELECT * FROM adm WHERE left(nama,1) not REGEXP '[a-zA-Z]' order by kode,parent;

Text: aqua: "#00ffff",
Regex: [a-z]+(?=:)
Explain: find word followed by colon
Match: aqua
ref: https://www.regular-expressions.info/lookaround.html