Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select distinct domain name from an email field?

Status
Not open for further replies.
jimoblak

jimoblak

Instructor
Joined
Oct 23, 2001
Messages
3,620
Location
US
Is it possible to select distinct domain names from an email field in a table in a single statement, extracting the domain after the token '@'?
 
Sort by date Sort by votes
Should be this I think :

Code: 
SELECT SUBSTRING_INDEX('user@domain.com', '@', -1)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question Question
Update column based on input from another column
Replies
6
Views
995
penguinspeaks
penguinspeaks
wilsjay22
  • Locked
  • Question Question
Freeing up disk space from information_schema
Replies
1
Views
765
jg2828
jg2828
Darryl Johnson
  • Locked
  • Question Question
Adding labor hours to a date time field
Replies
5
Views
610
Andrzejek
Andrzejek
martinkaeser
  • Locked
  • Question Question
MySQL Query for incrementing field from duplicates in database
Replies
4
Views
596
martinkaeser
martinkaeser
penguinspeaks
  • Locked
  • Question Question
Stored Procedures and triggers
Replies
9
Views
1K
penguinspeaks
penguinspeaks

Part and Inventory Search

Sponsor

Back
Top