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. Quote 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 Quote 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? Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.