Full-Text search on single row fails
Posted by:
George J
Date: March 15, 2010 02:46AM
Greetings,
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.
Subject
Views
Written By
Posted
Full-Text search on single row fails
5768
March 15, 2010 02:46AM
2569
March 21, 2010 06:19PM
2426
March 21, 2010 07:20PM
2322
March 22, 2010 08:38AM
2522
March 22, 2010 01:05PM
2377
March 23, 2010 12:07PM
2270
March 27, 2010 10:37AM
2505
March 28, 2010 05:16AM
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.