LENGTH

Find the length of text.

LENGTH returns the number of characters in a text. It is used to filter by text length in conditions.

SELECT name, LENGTH(name) AS uzun FROM customers;

This query puts the character count next to each name.

name, LENGTH(name) AS uzun is selected from customers.

LENGTH — details

Some databases use LEN; the ANSI standard is LENGTH. Spaces are counted; trim first to ignore them.

Select from customers those whose name is longer than 5 characters.

Show example solution

SELECT name
FROM customers
WHERE LENGTH(name) > 5

Text length

SELECT name, ____(name) FROM customers;

Show answer

SELECT name, LENGTH(name) FROM customers;

Next lesson: SUBSTRING