Hi!
I am developing a seach engine on my site, and am trying to make it with boolean mode.
My problem is that some of the results is based on “shirt” even that I am searching for t-shirt. How can I do this in a better way, and place the “shirt”-results later in the results?
SELECT * , (
( 1.3 * (
MATCH (
productname
)
AGAINST (
't-shirt'
IN BOOLEAN
MODE
) ) ) + ( 0.6 * (
MATCH (
description
)
AGAINST (
't-shirt'
IN BOOLEAN
MODE
) ) )
) AS relevance
FROM products
WHERE (
MATCH (
productname, description
)
AGAINST (
't-shirt'
IN BOOLEAN
MODE
)
)
ORDER BY relevance DESC
Thanks // Jimmit