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 ema
I would use this query:
SELECT DISTINCT SUBSTRING(email,LOCATE('@', email) ) FROM AddressList ;
Cheers,
Kent
sql, query, y'hear
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
: Re: help 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
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
domains.
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
Easy question I hope, relatively new user (< 6 months) here wanting to know
how to fashion a MySQL
select statement based on the following:
there is a list of managers and their email addresses. This list changes
all the time as we add and subtract different companies from the db. I
would like
