A
Anonymous
Guest
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!
Makarak
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!
Makarak