Hi,
How do I get a full-text relevance ranking when using IN BOOLEAN MODE?
The manual shows how to get the relevance, but if I try to apply the
same technique to a boolean search, I get a score of either 0 or 1 as
the relevance. There are relevance parameters < > for boolean searches,
so it must be possible?
select match(artHeadline,artTagline,artByline,artText) against('trucks'
IN BOOLEAN MODE) as score from NS_articles where
match(artHeadline,artTagline,artByline,artText) against('trucks' IN
BOOLEAN MODE) > 0;
query returns:
+-------+
| score |
+-------+
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
+-------+
TIA
Monte
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
