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
additiona
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
