Why not store them in separate columns? You could then have the domain
field be a foreign key into another table.
From: Ferindo Middleton [mailto:ferindo.middleton@stripped]
Sent: Friday, May 12, 2006 2:14 PM
Subject: how to extract common text string from field?
Suppose you have a field in a db table that holds email addresses and
all of the address end in domain.com. Is there a MySQL function that can
be used to extract the first part of the email address, the username
(the part of the email address before the 'domain.com' part of the email
I was hoping somehow to do this within a SELECT statement so instead of
seeing the email address I would see the username without the