SQL · String functions

split_part()

Returns one part of a delimited string. PostgreSQL.

sqlRunnable example sql course

Syntax

split_part(text, delimiter, n)

Example

Open in the lab

-- PostgreSQL
-- SELECT split_part('a/b/c', '/', 2);

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