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...,
On Jan 10, 2008 5:40 PM, Eben [EMAIL PROTECTED] wrote:
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.
Assuming what you want is all the data from your current query plus an
additional