Locating a character in an email address

Question

Accepted Answer

POSITION(substring IN string) returns the 1-based position of the first occurrence of substring, or 0 if not found. 'user@example.com': u=1, s=2, e=3, r=4, @=5. The @ sign is at position 5. PostgreSQL also accepts STRPOS(string, substring) with the arguments reversed.