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
5824
March 15, 2010 02:46AM
2597
March 21, 2010 06:19PM
2454
March 21, 2010 07:20PM
2348
March 22, 2010 08:38AM
2546
March 22, 2010 01:05PM
2402
March 23, 2010 12:07PM
2298
March 27, 2010 10:37AM
2530
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.