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 [EMAIL PROTECTED] 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 To: <[EMAIL PROTECTED]> 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]
