Robert, No problem. I actually considered the PHP option, and usually do since I use it quite a bit. However, what I was trying to accomplish was only a one time thing so I just decided to do it all with queries. Thank you though for your helpfulness, and everyone else too. What did I ever do without the Internet and the amazing resource it makes everyone!
Regards, Jonathan Duncan >>>"Robert A. Rosenberg" <[EMAIL PROTECTED]> 07/10 8:09 pm >>> At 17:25 -0600 on 07/09/2004, Jonathan Duncan wrote about Re: Weeding out duplicates: >For the information of someone who may need it in the future. I used >Jeffrey's idea for determining duplicates. Then I created a temporary >table, and used insert...select to put the id's of the duplicates in the >temporary table. Then it was a simple "delete from table where >temp.id=table.id". > >Thanks for the help. > >Jonathan Duncan I responded to your query earlier with a PHP/MySQL solution that was equivalent to this. I only saw your reply after sending my suggestion. Sorry for giving you an answer you had already discovered. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]