Kent,
Thursday, July 11, 2002, 9:22:52 PM, you wrote:
KH I would use this query:
KH SELECT DISTINCT SUBSTRING(email,LOCATE('@', email) ) FROM AddressList ;
So?
Syntax of your SQL statement is correct.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
Use SELECT DISTINCT.
Matthew Scarrow
ComIT Solutions Inc.
www.comit.ca
Phone: 519-442-0100
Fax: 519-442-0429
-Original Message-
From: Kirk Babb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 9:59 PM
To: [EMAIL PROTECTED]
Subject: help with MySQL SELECT statement
Easy
wait, how will the MySQL SELECT DISTINCT pick only one between these two
addresses (as an example):
[EMAIL PROTECTED]
[EMAIL PROTECTED]
I only need one email address each for alltel.com, one for ualr.edu, one for
target.com, etc. when there might be 50 email addresses from each of those
with MySQL SELECT statement
wait, how will the MySQL SELECT DISTINCT pick only one between these two
addresses (as an example):
[EMAIL PROTECTED]
[EMAIL PROTECTED]
I only need one email address each for alltel.com, one for ualr.edu, one for
target.com, etc. when there might be 50 email addresses