Counting comments

Zak Greant zak at
Mon Oct 18 01:11:19 UTC 2004


On Oct 16, 2004, at 17:19, Bradley Baetz wrote:
> select bug_id from longdescs where bug_id in (SELECT id from
> bugs where ....) GROUP BY bug_id HAVING count(*) > 1
> In mysql you'll have to do it as a temp table + join.

In MySQL version 4.0 or less, you will have to do it as a temp table 
and join. MySQL 4.1+ should support this syntax.


More information about the developers mailing list