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..
Code SQL:SELECT SQL_CALC_FOUND_ROWS *, IF((`category`IN ('dg43nb')),3,1)+ MATCH(title) AGAINST('+dg43nb*' IN BOOLEAN MODE)*3+ MATCH(description) AGAINST('+dg43nb*' IN BOOLEAN MODE)*0.2 AS score FROM inventory i LEFT JOIN category c ON i.cat_id = c.cat_id WHERE MATCH(title,description) 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