I know that using SELECT DISTINCT(colname) will result in output that does
not contain any duplicates from that column. But how would I output JUST the
duplicates? If I have as part of a table a column containing email
addresses, and I want to list just the duplicate addresses rather than the
Question answered.
Thanks to all who responded.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, archive.id,
archive.title WHERE data.favorite = 'Y',
archive.favorite = 'Y'
Assistance, please? And can anyone recommend a good
MySQL reference that's a little easier for a schlub
like me to understand?
Thanks,
Bob
Bob Sawyer
---
Pixellated!
Design:Develop:Deliver
www.pixellated.org
on SQL.
SELECT data.id, data.title
FROM data,archive
WHERE data.favorite=archive.favorite AND data.favorite='Y';
Bob Sawyer wrote:
First, a little rant: I don't know what it is about
the MySQL docs that make them so difficult for me to
read, but try as I may, I have the most difficult time
with this
version?
Thanks,
Bob Sawyer
---
Pixellated!
Design:Develop:Deliver
www.pixellated.org
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list