Comparing rows in the same table

[Chris1981]

Hey All,

Im having trouble with a query of mine.

I have a table that has quite a few records ... i want to compare the field, round and location columns of my table and if there are more than one, then limit it to display only one of them.

How would i go about doing this ..

Cheers

[bretticus]

I would suggest not worrying about finding out if you have more than one. Just use the LIMIT functionality of MySQL ( I assume you are using MySQL.)

$query = "SELECT * FROM `table` WHERE field='value-looked-for' AND round = 'value-looked-for' AND location= 'value-looked-for' LIMIT 1";

[Chris1981]

That would only spit out 1 record though ... i want to spit out one of each record that has the same field, round and location ... there could be quite a few of these.

If that makes sense

[troybtj]

SELECT COUNT(*) AS dupes, value1, value2, value3 FROM tableGROUP BY value1,value2, value3 HAVING dupes > 1;