Select If LENGTH is LESSTHAN or = to 9

where length(field) <=9 limit 100;

Select if LENGTH is GREATERTHAN or = 10

where length(field) >=10 limit 100;

SELECT if LENGTH = 10

where length(field) = 10 limit 100;