If you have a table as follows:

and you would like to remove all duplicate rows, the easiest method is to create an unique index like so:

alter ignore table TABLENAME add unique index INDEXNAME (Field1, Field2, Field3); 

then

alter table PCODES drop index xxx;

all the duplicate rows will be removed as follows: