var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Trying to search for a word in a field
SELECT * FROM posts where match(entry) against('bling');
Gives me the error
#1191 - Can't find FULLTEXT index matching the column list
Is there a way to search without changing the column to "FULLTEXT"? Also what are the cons to changing it to fulltext, will it be slower for regular queries?
yes, all you have to do is specify IN BOOLEAN MODE
Originally Posted by s0me0ne
not at all, if your search doesn't use MATCH then the fulltext index is ignored
Also what are the cons to changing it to fulltext, will it be slower for regular queries?
Tags for this Thread