SQL LEN function in MySQL Sep 8, 2010 SQL: The LEN() function returns the length of the value in a text field. SELECT LEN(column_name) FROM table_name BUT: in MySQL LEN() does NOT work,it’s called LENGTH(). SELECT * FROM table_name WHERE LENGTH(column_name) < 5 via 1 2