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.
word counts from text field
Moderator: General Moderators
The first thing that came to mind is to make your search a regular expressions, then throw it and the string you're searching at preg_match_all().
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.