How to select domain name from email address
- by ugesh.gali
I have a email address like user1@gmail.com and user2@ymail.com user3@hotmail.com ... etc
I want a Mysql select query so that it would trim user names and .com an returns output as
gmail,ymail,hotmail etc