count word

[tamparinn]

how can i count SUM from this sql statement

Code: Select all

SUM( LENGTH(message) - LENGTH(REPLACE(message, ' ', ''))+1) AS sum
FROM mdl_forum_posts WHERE userid = 29254
AND created>=1329692400 and created<=1339279200
Group by message
HAVING sum>=30

[Nullsig]

To Count the number of records found you would just select a second variable "COUNT(*) from the result set.

Code: Select all

    SELECT COUNT(*) AS count, SUM( LENGTH(message) - LENGTH(REPLACE(message, ' ', ''))+1) AS sum
    FROM mdl_forum_posts WHERE userid = 29254
    AND created>=1329692400 and created<=1339279200
    Group by message
    HAVING sum>=30