SUBSTRING

Slice a part of a string.

With SUBSTRING you take a part of a text. You specify the start and length to pick the slice you want.

SELECT SUBSTRING(name, 1, 3) AS ilk_uc FROM customers;

This query returns the first 3 characters of each name.

SUBSTRING(name, 1, 3) AS ilk_uc is selected from customers.

SUBSTRING — details

Some databases use SUBSTR or LEFT. The start index is 1-based, not 0. Without length it goes to the end.

Select the first 2 characters of name aliased as first from customers.

Show example solution

SELECT SUBSTRING(name, 1, 2) AS ilk
FROM customers

Take substring

SELECT ____(name, 1, 3) FROM customers;

Show answer

SELECT SUBSTRING(name, 1, 3) FROM customers;

Next lesson: TRIM