help with count in grouped query

[Eben]

I have this query:

SELECT table.id,table.field_1,table.field_2,COUNT(table.field_1) as total
FROM table
WHERE MATCH table.field_1 AGAINST ('some text')
GROUP BY table.field_1,table.field_2
which returns aggregate results like:

1, data..., data..., 3
2, data..., data..., 1
3, data..., data..., 5
etc...

I want to be able to do count of the total records brought back by this 
query... but since I am using the group by I can't use COUNT() in the 
desired way.  So let's say this query returns 15 records, how might I 
refactor this query so I can just get back one record showing that it 
returned 15 results?

Any suggestions or pointers are appreciated

thanks,
Eben


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]