we can use
'<[^@]+@([^>]+)>'
SQL:
SELECT id, substring(email_from from '<[^@]+@([^>]+)>') AS domain, body, date FROM Table
Result:
hotmail.com