Find Duplicates?

[RaythXC]

Ok I recently just added my whole yu-gi-oh tcg collection into a mysql database so I can keep track of what i have, what set they’re from and the rarity.

I know there are a couple that have identical entries, so is there a single mysql query that I can just pull these out (like name=name set=set rarity=rarity) without manually looping through my whole database (considering its it 137 cards now, but will be 500+ by the end of next week)

[ttbakiatwoam]

If you use phpMyAdmin as a GUI it will make manually doing it a lot easier because you can sort by each row in the table and see where your duplicates are. Or you could write a script something like,

DROP pid FROM table WHERE name=name;

[RaythXC]

found out howto do it.

[php]
$query= “SELECT ,count() as quantity FROM ygo_cards GROUP BY set,name,rarity”;
[/php]