"Floris van den Berg" <flvdbergwxs.nl> wrote in message
news:bkejov$kjt$1reader08.wxs.nl...You've not specified the table join and to use the count function you need> Is something like the following possible?
> SELECT products.id, count(*) as counter FROM products, keywords WHERE
> keywords.keyword in ("bla","hi","hello") AND counter > 2;
> Can't get it to work :/
to use GROUP BY clause. Having said that I don't think the counter>2 will
work anyway, not allowed to use the results of group function for extraction
criteria. You'll probably need to create a temp table with the count results
and then extract the final result set from that. Sub queries may do the
trick as well but depends on what version of Mysql you have.