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 reliably: CREATE TABLE newtable SELECT DISTINCT * FROM oldtable; - seb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
