full-text index issue in mysql 5

I was having issues with full-text index using MySQL 5.  Basically, on one host I would see results with the same query but not on another host. Here is the sample query I used: SELECT * from table_name WHERE MATCH(Description, Title) AGAINST (‘yes” IN BOOLEAN MODE) AND title like ‘%yes%’ ; Because the length of [...]

Share