Hi Coders I have a table in mysql with the following structure
I need to remove all the duplicates but leave one record using a php function.
for example the data is like this:
1 | ABC | 1
2 | XYZ | 1
3 | ABC | 2
So I want to delete the duplicate entry for [ABC] and the end result should looklike this:
1| ABC | 1
2| XYZ | 1
Ideally I would like a php function which I can call from website evry now and then , but if it is easier to implement using sql that is fine too.
Thanks in adavance