MySQL-query

Could you help me with this mysql-search problem.

I have tried everything and i still haven't find an answer for it.

I want to make a little search witch counts query from a column.

For example if have a table like:

+----+-----------------------+
| id | string |
+----+-----------------------+
| 1 | file test test array |
| 2 | test test test test |
| 3 | find search test |
| 4 | empty set |
+----+-----------------------+

Let say I have a form with one field, named "query". How can i make
mysql-query count that "query" from column "string"?

I don't know if you got already my point but if i put it this way. I use
that same table here and i'd like to search it with querystring "test".
I should give me result like this:


+----+--------+
| id | count |
+----+--------+
| 1 | 2 |
| 2 | 3 |
| 3 | 1 |
| 4 | 0 |
+----+--------+

So it just counts that word "test" from that column "string". I think
this is quite easy but I haven't found any answer for this problem.

I would love to have any help for this!

Thanks!!

------------------

.bugi