How do you set a field match as optional, but LITERAL

[fat joe]

Below my fulltext search query

****************
SELECT
description,title,category,
MATCH(c.category) AGAINST('scanner' IN BOOLEAN MODE)*3+
MATCH(i.title) AGAINST('+scanner*' IN BOOLEAN MODE)*3+
AS score
FROM inventory i,category c
WHERE MATCH(title,description) AGAINST('+scanner*' IN BOOLEAN MODE)
and i.cat_id = c.cat_id
ORDER by score desc
LIMIT 0, 500
****************

I want to change: MATCH(c.category) AGAINST('scanner' IN BOOLEAN MODE)*3+

So that finding scanner in c.category is OPTIONAL,
but to only match LITERALLY... so where c.category = scanner

Currently it is matching where scanner is contained within c.category!



Edited 3 time(s). Last edit at 07/03/2008 01:48AM by fat joe.