开发者

Fulltext index in MySQL for mediumtext field?

开发者 https://www.devze.com 2023-03-07 16:59 出处:网络
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 flawe

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

0

精彩评论

暂无评论...
验证码 换一张
取 消