Hi,
Does anybody have any ideas about this?
We use the MySQL MATCH function to search a product catalogue (which has a fulltext index on 3 columns). An example query looks like this:
Code:
SELECT p.Name, etc FROM Products AS p WHERE MATCH(p.Name, p.Description, p.Keywords) AGAINST ("q 10") GROUP BY p.ID ORDER BY MATCH(p.Name, p.Description, p.Keywords) AGAINST ("q 10") DESC
The problem is that many of these products have words or phrases that are 1 or 2 characters long (eg "Q 10").
We want to avoid changing the min. word length so we don't impact on performance or other databases. Am I right in thinking that the only way round it is to revert to using LIKE(%Q 10%) , or is there some way of altering the MATCH fuction to find what we need ( or mabye using MATCH in the first place and reverting to LIKE if no results are returned - can this be done in one query?)
Thanks for your help.
