kingberrill of SQL
6/1/2017 - 9:17 PM

LENGTH()

LENGTH()

SELECT LENGTH(<value or column>) FROM <tables>;

-- bring back 1st largest title with longest length
SELECT title, LENGTH(title) AS longest_length FROM books ORDER BY longest_Length DESC LIMIT 1 ;

-- Find the actor with the longest name

SELECT name FROM actors ORDER BY LENGTH(name) ASC LIMIT 1;