Delete duplicate rows from mysql in php function

IN PROGRESS
Bids
10
Avg Bid (USD)
$20
Project Budget (USD)
$25 - $30

Project Description:
Hi Coders I have a table in mysql with the following structure
Tablename: tblItems
Fields
[ID]-->PK INT
ItemName -->Varchar(50)
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

Skills required:
MySQL, PHP, Script Install, Shell Script, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing, Windows Desktop
Hire emailsolutionvw
Project posted by:
emailsolutionvw Australia
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 40.8
in 14 days
$ 25.5
in 14 days
$ 25.5
in 14 days
Hire discocactus
$ 10
in 14 days
$ 20.4
in 14 days
Hire lolingualtd
$ 25.5
in 14 days
Hire parama4uvw
$ 20.4
in 14 days
Hire martdesignstudio
$ 5
in 14 days
Hire ebione
$ 15
in 14 days
$ 10
in 14 days