Match

[twinzen]

hi, i asked this in newbies section before but i guess i was a bit vague, so i'll try here.

is it possible to limit the rows that MATCH will look into (or limit the result found by MATCH) in one query.

i have a query like

SELECT name, 
match (name,text) against (' searchword ') as relevance 
FROM virt393.toode 
WHERE 
match (name,text) against ('searchword')>0 
HAVING relevance>0 
ORDER BY relevance DESC 

no i would like to add to the query something like:

id IN ('".implode("','",$ids)."') AND value1 > "somevalue"

i want to have it in one query because i want to be able to sort it by relevance.

any ideas? hope you can help...

[twinzen]

figured it out with some help...it's simple but i had ben trying the wrong way...

this works well:

SELECT name, 
match (name,text) against (' searchword ') as relevance 
FROM virt393.toode 
WHERE 
match (name,text) against ('searchword')>0 
AND id IN ('".implode("','",$ids)."') 
AND value1 > "somevalue"
HAVING relevance>0 
ORDER BY relevance DESC