ok Posted December 13, 2008 Share Posted December 13, 2008 In the table i found out there are duplicate names, I want to remove the duplicate anmes and retain only one name. Can you show me simple mysql query for this. thank you. Link to comment https://forums.phpfreaks.com/topic/136807-how-to-remove-duplicate-names/ Share on other sites More sharing options...
suma237 Posted December 13, 2008 Share Posted December 13, 2008 select Distinct(col_name) from table name;-apply this query and delete the rest Link to comment https://forums.phpfreaks.com/topic/136807-how-to-remove-duplicate-names/#findComment-714490 Share on other sites More sharing options...
ok Posted December 13, 2008 Author Share Posted December 13, 2008 anyone has better answer? Link to comment https://forums.phpfreaks.com/topic/136807-how-to-remove-duplicate-names/#findComment-714495 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.