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