How to delete duplicate entries in a field

[hoverinc]

Good morning everybody... need to know please how to delete duplicate id in the same field.

 

Any help is most appreciated

[PFMaBiSmAd]

Define: duplicate id in the same field? An example of what data you have would help.

[hoverinc]

Thanks PFMaBiSmAd i have a field which contains data they are number of type int, so i have combined them from two tables and they are in field but when i select field from table where the same field=some condition    returns about 3 records of the same data, that's i want to eliminate the redundant records, hope it is clear, if no i hope to make it better clear so that can have some solution, with so many thanks again PFMaBiSmAd

[hoverinc]

Thanks i solved it using this

mysql> INSERT IGNORE INTO person_tbl (last_name, first_name)

    -> VALUES( 'Jay', 'Thomas');

Query OK, 1 row affected (0.00 sec)

mysql> INSERT IGNORE INTO person_tbl (last_name, first_name)

    -> VALUES( 'Jay', 'Thomas');

Query OK, 0 rows affected (0.00 sec)