PostgreSQL›String Functions›SPLIT_PART
←REVERSE

SPLIT_PARTString Functions

INITCAP→

Returns the nth part after splitting by a delimiter.

Syntax

SPLIT_PART(str, delim, n)

Example

Enter values below to update the example in real time.

email→
domain→
users→
-- 이메일에서 도메인 추출
SELECT SPLIT_PART(email, '@', 2) AS domain
FROM users;