SQL SPLIT_PART

What & Why

SPLIT_PART(text, delimiter, n) splits a string wherever the delimiter appears, and returns the nth piece (1-indexed). This handles the "email domain," "username-from-email," and similar delimiter-based extraction patterns more directly than POSITION + SUBSTRING combined.

See How It Works

SELECT
  id,
  email,
  SPLIT_PART(email, '@', 1) AS email_name,
  LOWER(SPLIT_PART(email, '@', 2)) AS email_domain,
  SPLIT_PART(LOWER(SPLIT_PART(email, '@', 2)), '.', 1) AS domain_name
FROM marketing.leads
WHERE POSITION('@' IN email) > 1
ORDER BY id;