2. When you mean "location of matches", do you mean something like highlighting? That's the responsibility of the interface, not the database. Remember, MySQL is really "just" a database engine. It will find your data fast, but it's up to you to present it in a nice format. But, highlighting is fairly easy using grep, which is available in just about any front end you may be using (Perl, Shell, PHP, etc.).
On Oct 25, 2004, at 8:37 PM, Jalil Feghhi wrote:
In the MySQL documentation, it says that: Boolean full-text searches have these characteristics:
* They do not use the 50% threshold.
* They do not automatically sort rows in order of decreasing
relevance. You can see this from the preceding query result: The row
with the highest relevance is the one that contains ``MySQL'' twice, but
it is listed last, not first.
* They can work even without a FULLTEXT index, although this would be slow.
* The minimum and maximum word length full-text parameters apply.
* The stopword list applies.
I had two questions:
1. How are the returned rows sorted in the boolean full-text searches?
2. Is there any way to get more information (other than the score) from MySQL? For example, can we find out the location of matches?
Regards,
-Jalil
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
