Is it at all possible to add a working fulltext index on a mediumtext field in oracle? I have been able to make an index, but I do not get any results when I query it. It might be that my sql is flawed: (ps. I am absolutely sure that the 'someText' part is in the DB).
SELECT *
FROM Products
WHERE CONTAINS (ProductDescription, 'someText' );
I also tried with:
SELECT *
FROM Products
WHERE CONTAINS (ProductDescription, 'someText' )>0;
But no results.
T开发者_StackOverflow社区he strange thing is that the query returns no error, it simply does not return results. It might be that my index is inproperly created, but in "phpMyAdmin" it is listed as one of the indexes for my table. Any ideas?
How have you built your index ?
Specifically, are you syncing the index changes to the table changes ON COMMIT
精彩评论