• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Searching for the frequency of a word

Jake Bunce

XenForo moderator
Staff member
#4
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

Well-known member
#5
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?
 

Brogan

XenForo moderator
Staff member
#8
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.