Why not store them in separate columns? You could then have the domain
field be a foreign key into another table.
-----Original Message-----
From: Ferindo Middleton [mailto:ferindo.middleton@stripped]
Sent: Friday, May 12, 2006 2:14 PM
To: mysql@stripped
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
address).
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
'domain.com'
part.
Ferindo
