MySQL Forums
Forum List  »  Full-Text Search

Can I count the word in each row, when have some word occur many times
Posted by: Peter Dog
Date: April 08, 2009 12:29PM

Hello,
I have some problem about Natural Language Full-Text Searches

My data is:
CREATE TABLE quotes (quote CHAR(100),FULLTEXT (quote));
INSERT INTO quotes VALUES
('Special times require special socks'),
('Knock three times on the ceiling'),
('Boliauns are weeds'),
('The leprechaun''s gold');

My Query is:
SELECT COUNT(*) from quotes WHERE MATCH(quote) AGAINST('special');

This query has result = 1 but I want count the word 'special' that appear in first low to 2
Possible?

Please help me

Options: ReplyQuote


Subject
Views
Written By
Posted
Can I count the word in each row, when have some word occur many times
4839
April 08, 2009 12:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.