Searching for the frequency of a word

[ChemicalKicks]

How would I go about getting the frequency of use for a specific word across all posts in my forum?

 

[Fuhrmann]

Testing a query in here...

 

[ChemicalKicks]

Testing a query in here...

Nope more like a SQL query

 

[Jake Bunce]

You can search posts for a word. And you can count the number of matching posts. But I don't know of a way to count the number of occurrences of a word in a post with just SQL.

 

[ChemicalKicks]

You can search posts for a word. And you can count the number of matching posts. But I don't know of a way to count the number of occurrences of a word in a post with just SQL.

Bugger, I thought I could count the individual instances of a word. How would I count the number of posts that contained a specific word?

 

[Fuhrmann]

You can use this SQL query and then count the results.

SELECT post_id
FROM xf_post
WHERE message LIKE '%da%'
GROUP by post_id

 

[ChemicalKicks]

That will give number of posts with the word but not the frequency of the word within all posts?

 

[Paul B]

If the table isn't too large, you can download it and open it in Notepad++.

You can then search for the word and it will return the total number.

 

[Fuhrmann]

That will give number of posts with the word but not the frequency of the word within all posts?

Yes.

 

[ChemicalKicks]

Don't know how large the post table is but the database is about 1Gb, I think notepad might not be impressed

 

[ChemicalKicks]

If the table isn't too large, you can download it and open it in Notepad++.

You can then search for the word and it will return the total number.

This worked best.

The word occurred no less than 77,000 hehehe