Full-text and sort by score?

[vigour]

Dear list,

I need to know how to sort full-text by score. This is the query I'm using right now.

sql = "SELECT product_id, bild, bilden_forestaller FROM products WHERE MATCH (bilden_forestaller) AGAINST ('$fritext')";

I have tried several ways but I can't get it to work. Please tell me how to rewrite my query. I also want to show the score (in percent) for every row I get back from the query.

[halojoy]

vigour wrote:

Dear list,
I need to know how to sort full-text by score.
I have tried several ways but I can't get it to work.
Please tell me how to rewrite my query.
I also want to show the score (in percent) for every row I get back from the query.

sql = 
"SELECT product_id, bild, bilden_forestaller 
FROM products 
WHERE MATCH (bilden_forestaller) AGAINST ('$fritext')";

bilden_forestaller ~= image_shows (translated)

The score in percent % of:
what of what ????
... precent 'a' of 'b' is 17.3%

Tacksam for svar.