Returns the matched substring of a regular expression.
Syntax
REGEXP_SUBSTR(str, pat [, ...])Example
Enter values below to update the example in real time.
email→domain→users→-- 이메일 도메인 추출
SELECT REGEXP_SUBSTR(email, '[^@]+', 1, 2) AS domain
FROM users;