Re: deleting duplicates from table

2004-07-19 Thread Stephen E. Bacher
Wesley Furgiuele <[EMAIL PROTECTED]> wrote: >I think one way to solve it would be to move your data to a new copy of >your table. Assuming record_ref and keyword are separate fields... > >CREATE TABLE newtable SELECT * FROM oldtable GROUP BY CONCAT( >record_ref, keyword ); Or, more simply and

Re: deleting duplicates from table

2004-07-16 Thread Wesley Furgiuele
I think one way to solve it would be to move your data to a new copy of your table. Assuming record_ref and keyword are separate fields... CREATE TABLE newtable SELECT * FROM oldtable GROUP BY CONCAT( record_ref, keyword ); Wes On Jul 16, 2004, at 7:08 PM, L a n a wrote: Hello, I'm trying to s