<p>How to query to get count of matching words in a field, specifically in MySQL.
simply i need to get how many times a "search terms"appear in the field value.</p>

<p>for example, the value is "one two one onetwo" so when i search for word "one" it should give me 3</p>

<p>is it possible? because currently i just extract the value out of database and do the counting with server side language.</p>

<p>Thank you</p>

Are you looking to find a query that, given a list of words, returns the number of matching words in a database field?
eg:
Database table has
```
ID    Terms
1     cat, dog, bird, horse
```
then running a check on the words "cat, horse" returns 2?
If so, I suggest you do your checking
outside
of SQL, in whatever language you're doing the rest of your processing in. SQL isn't designed for this level of processing.
You could
possibly
use a stored procedure to cycle through what words you're needing to check, but I doubt it would be efficient or highly effective.
Of course, if I'm misinterpreting your request, I could be all wrong =)