Selecting Domain Name from Email Address
<p>I have a list of E-Mail addresses of varying domain name e.g. abc123@gmail.com, def456@woodstock.br, ghi789@jetbrains.net and was wondering how to get just the domain name (e.g. gmail, woodstock, jetbrains) from the E-Mails. So far I've gotten:</p>

<p><code>SELECT SUBSTR(Email, INSTR(Email, '@') + 1) as DOMAIN FROM Table</code></p>

<p>Which removes everything in front of and the '@' sign.
I've seen a similar post for MySQL but as SQLite doesn't have the SUBSTRING_INDEX function I was wondering what alternative there were for SQLite</p>

<p>Any help would be great appreciated :)</p>