word counts from text field
Posted: Fri Jun 09, 2006 12:31 pm
Hi,
I want to calculate the numbers of occurances of a word in a text type table filed in mysql query.
For ex. say filed name 'content' in a 'pages' table have value "This is a very good web site", then query for "is" word shoud return 2.
Thanks for your valuable help.
I want to calculate the numbers of occurances of a word in a text type table filed in mysql query.
For ex. say filed name 'content' in a 'pages' table have value "This is a very good web site", then query for "is" word shoud return 2.
Thanks for your valuable help.