MySQL help

[Jay]

I need a little help from all you MySQL gurus out there. I am setting up (yet another) web project and want to use fulltext searching for my form search. The statement I am using is as follows:

SELECT name,description,manufacturer,retailer,parent,department,link,imageThumb,imageLarge,price, MATCH(name) AGAINST ('$searchKeyword') AS RANK FROM stock ORDER BY RANK DESC LIMIT $searchLimit;

where $searchKeyword and $searchLimit are variables passed through the function that calls the search.

HOWEVER, I only want to return items that score more than 0 on rank (search weighting) as other results are non applicable. HOw do I use FULLTEXT to return only those results?

One option I thought of was to explode the keyphrase and add '+' onto the front of each keyword in the keyphrase and then searching in BOOLEAN mode but surely there must be a simpler answer.

[Conor]

I'm just going to have a look, but the quick impression is why can't you concatenate '+' onto the variable in the select?

Sorry I'm more on the Ora side of things

[Conor]

Alternatively can't you use the same syntax in the where?

i.e.

select match(blah) against(blah) as rank
where match(blah) against(blah > 0
order by Rank

[Jay]

Originally Posted by Conor

Alternatively can't you use the same syntax in the where?

i.e.

select match(blah) against(blah) as rank
where match(blah) against(blah > 0
order by Rank

That works Conor - thanks. Having read it, its obvious but it wasn't at 11.45pm last night after a 17 hour day

[Conor]

I can imagine. Although I haven't worked a 17 hour day in year....and if I did, the last thing I'd want to do is look at a Db