duplicates

[OwenTheSamoan]

How would I make a query to show where there is more than one of kind in a particular field?

example--

select * from table where "something" appears more than once;

[bretticus]

try something like ...

$sql = "SELECT count( * ) AS result, `something`
FROM `table`
GROUP BY `something` HAVING result >1
ORDER BY result DESC";

[OwenTheSamoan]

Thank you very much!