I have a column that stores alpha IDs. They all must be 5 cars long, but I just found a few that were 4. How do I add a query condition to find all values that have less then 5 characters long?
GOt it. Used this:
crDir_key REGEXP '^([A-Z]{4})$'