MySQL Lists: mysql: Re: Tricky query

List:	General Discussion	« Previous Message Next Message »
From:	Morten	Date:	August 4 2006 7:49pm
Subject:	Re: Tricky query
View as plain text

>>
>>
> How about:
> SELECT DISTINCT `key`, COUNT(`key`) AS c
> FROM `table` WHERE `value` in (8,9,10)
> HAVING c=3;
> 

Clever! Thanks :-)