If you look at the "planned" improvements of MySQL, a few of the major items have to do with full text searching.
On Oct 26, 2004, at 7:39 PM, Jalil Feghhi wrote:
Brent,
Thanks for the reply.
1. Is there any way to sort the boolean full-text search results in
orther of relevance as in non-bolean mode? I think it is very important.
2. Yes, that is what I meant. You are right. I look into grep.
Thanks,
-Jalil
-----Original Message----- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 6:30 AM To: Jalil Feghhi Cc: [EMAIL PROTECTED] Subject: Re: Full-Text Search
1. The rows are "sorted" in the same order as any other query that doesn't have and order by specified, which means usually in the order they were entered.
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- 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]
