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]
