I don't think theres a MySQL function to return the number of times a phrase
appears inside a field.
Another way you could achieve the same goal:
SELECT field FROM table WHERE field LIKE '%word%word%word%'
^-- would match on three occurences of 'word'
If you need a count of the number of times 'word' appears in that field
you're out of luck so far as the MySQL SELECT() is concerned. You'll have
to select those rows and then count the # of times 'word' appears in the
returned data.
-Original Message-
From: Michael Collins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 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
with a specific column, not count() of all columns that have that
word.
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA ||| http://www.lassodev.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
