use of fulltext index in article_value column with MATCH ... AGAINST

[rodolfor]

I need to optimize the use of table article_search_index

Sniffing full text search for the word "pluto" from web interface I see this filter:

Code: Select all

where ArticleFulltext.article_value like '%pluto%'

Article_value is of type mediumtext so I cannot create an index.
But I can create a fulltext index

To use the fulltext index the query must be:

Code: Select all

MATCH(ArticleFulltext.article_value) AGAINST ('pluto' IN BOOLEAN MODE)

My question is: there is a method to activate MATCH ... AGAINST filter directly from system configuration or I need to chenge the code?

thanks