mysql:文字列の長さで抽出・並び替え

SELECT * FROM tbl WHERE CHAR_LENGTH(col)>30

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