Well, using the DISTINCT keyword would eliminate any duplicates, and then you could just pick randomly from those results.