Extracts a substring by position and length.
Syntax
SUBSTRING(str FROM pos FOR len)Example
Enter values below to update the example in real time.
email→domain→users→-- 이메일 도메인 추출
SELECT SUBSTRING(email FROM POSITION('@' IN email) + 1) AS domain
FROM users;