Count the number of matched words in a record



Hi Everyone!

I have a question to ask about counting the number of matched words in a record.

Suppose I have a table with the field ID and Content
And here is its value
ID: 1
Content: This is just an example of counting the matched words when we search for a keyword and in this content I am looking for the word word.

What I want is that when I search the word "word", I will get the result 4 (it is the number of matched words "word").
I have searched many sites and tutorials. Most of them use the sql statement match(..) against(..). But when I try it, I have no luck to get the result.

The reason that I want this is that I want to sort the result according to the number of matched words.

Your help is highly appreciated!