Count occurrence of word in a column

How can I most efficiently return just the count of some word in a large text field in a MySQL db, without returning the actual text field contents. I am looking for the number of times the word appears with a specific column, not count() of all columns that have that word. -- Michael __

RE: Count occurrence of word in a column

, 2001 12:22 PM To: [EMAIL PROTECTED] Subject: Count occurrence of word in a column How can I most efficiently return just the count of some word in a large text field in a MySQL db, without returning the actual text field contents. I am looking for the number of times the word appears