MySQL Forums
Forum List  »  Full-Text Search

Full-Text search on single row fails
Posted by: George J
Date: March 15, 2010 02:46AM


The following block

CREATE TABLE page (content LONGTEXT, FULLTEXT (content)) ENGINE = MyISAM COLLATE = utf8_unicode_ci;
INSERT INTO page VALUES ('value');
SELECT * FROM page WHERE MATCH (content) AGAINST ('value');

fails to select the only row in the table.
Apologies if this is something typical but I can't seem to find why this is happening.

Thanks in advance.

Options: ReplyQuote

Written By
Full-Text search on single row fails
March 15, 2010 02:46AM

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.