ok i'm doing a big text seach for a site wide search engine thingy. Anyway i want to tell how many occurance of each word is in the text field.
erm
something like:
select * from search where keywords='$searchtext'
then work out how many times each word appeared in each result.