I've never heard of select distinct not working...

Is that the exact SQL you are using?

WARNING [EMAIL PROTECTED] address is an endangered species -- Use
Wanna help me out?  Like Music?  Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
----- Original Message -----
From: Tom Churm <[EMAIL PROTECTED]>
Newsgroups: php.general
Sent: Friday, September 28, 2001 7:29 AM
Subject: MySQL - Selecting Unique Entries

> hi,
> i need to weed out all duplicate entries in a select statement.
> i've done research and have discovered 2 different possible solutions
> for this.  i'd like to know which one is better to use?
> after trying them out on MySQL, Select Distinct appears to be highly
> unreliable.  i get somewhat better results when i use Select Distinct
> trim(seminar_name), but this Group By solution seems to work better:
> SELECT seminar_name
> FROM student_table GROUP BY seminar_name
> SELECT DISTINCT seminar_name
> FROM student_table
> thanks for the advice,
> tom

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to