SQL · Functions and expressions

substring()

Extracts part of a string. SQLite uses substr(); PostgreSQL also accepts substring(text from start for length).

sqlRunnable example sql course

Syntax

substr(text, start, length)

Example

Open in the lab

SELECT substr('EduByte', 1, 3) AS first_three;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.