I need help with my product search query.
Overall I'd appreciate any critique / tweak suggestions,
more importantly though I have an issue..
The reason I implemented this was to stop people
searching for "ipod" and getting results like "tripod"
but now my issue is if I search for "dg43nb" I get 0 results
(but I want to get "BOXd43nb")
So I need some guidance as to what my options are here.
Below is my query as it stands..
SELECT SQL_CALC_FOUND_ROWS *,
MATCH(title) AGAINST('+dg43nb*' IN BOOLEAN MODE)*3+
MATCH(description) AGAINST('+dg43nb*' IN BOOLEAN MODE)*0.2
FROM inventory i
LEFT JOIN category c
ON i.cat_id = c.cat_id
AGAINST('+dg43nb*' IN BOOLEAN MODE)
OR product_code = 'dg43nb'
ORDER BY score desc
any advice appreciated.
who knows if I'm lucky maybe r937 will swing by lol