Hello,
My search query splits the keyword by dots and only returns results for the first section.
Eg. when searching for PROD134.485.125 I get results for PROD134
Is there a way around this?
I have tried adding double quotes around the keyword but doesn't seem to make a difference.
If it helps, the query:
SELECT DISTINCT(product_id), *,
(0.7 * ( MATCH (product_id)
AGAINST('PROD645.46.759' IN BOOLEAN MODE)) +
(0.1 * (MATCH (description)
AGAINST ('PROD645.46.759' IN BOOLEAN MODE)))) AS Relavance
FROM MY_TABLE
WHERE ( MATCH (product_id,description)
AGAINST('PROD645.46.759' IN BOOLEAN MODE)) >= 1