SELECT * FROM tbl WHERE CHAR_LENGTH(col)>30
SELECT * FROM tbl ORDER BY CHAR_LENGTH(col) ASC LIMIT 0, 100