I've got a problem with my site whereby if I search for 'vs' that no results are being returned, even though it's completely valid and does return results if you use a IS LIKE query.
Here is the query I'm using:
Anyone any ideas why this isn't working but if the 'vs' is substituted for 'vm', it does?
Here is the query I'm using:
Code:
SELECT SQL_CALC_FOUND_ROWS main.*, MATCH(KEYWORDS,CAPTION,REF) AGAINST ('+vs ' IN BOOLEAN MODE) AS score FROM main WHERE MATCH(KEYWORDS,CAPTION,REF) AGAINST ('+vs ' IN BOOLEAN MODE) ORDER BY score DESC LIMIT 0, 36Anyone any ideas why this isn't working but if the 'vs' is substituted for 'vm', it does?