i need your advice on how to rectify a problem ...

[steamPunk]

i have a db table 'comm_li' that contains the items in customer orders

all the columns in the table are allowed to have duplicate values

but through an error of programming on my part there are some entire duplicate rows that i need to remove just leaving one of them

here's the table

DO_Piece varchar(9) NOT NULL,
ID_Commande_Site int(11) NOT NULL,
AR_REF varchar(19) NOT NULL,
AR_PrixHT decimal(6,2) NOT NULL,
QUANTITE mediumint(9) NOT NULL,

and there are 790 rows at the moment so it's not a huge task - but what would be the best way of going about doing it ?

thanks

[steamPunk]

erm don't worry about this one - i think that the duplicated entries will be deleted as the orders are archived