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 gkittelson 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
Oct 23, 2001
3,620
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
Update column based on input from another column 3
Replies
6
Views
404
penguinspeaks
penguinspeaks
wilsjay22
  • Locked
  • Question
Freeing up disk space from information_schema
Replies
1
Views
320
jg2828
jg2828
Darryl Johnson
  • Locked
  • Question
Adding labor hours to a date time field
Replies
5
Views
200
Andrzejek
Andrzejek
martinkaeser
  • Locked
  • Question
MySQL Query for incrementing field from duplicates in database
Replies
4
Views
172
martinkaeser
martinkaeser
penguinspeaks
  • Locked
  • Question
Stored Procedures and triggers
Replies
9
Views
415
penguinspeaks
penguinspeaks

Part and Inventory Search

Sponsor

Back
Top