Nick,
Thursday, June 13, 2002, 12:14:16 AM, you wrote:
NB> This is a new area for me, so it may sound like a stupid question, but
NB> what do you mean by FULLTEXT indexes?
In MySQL you can use full-text search on varchar or text columns. You
can find more info in the MySQL manual:
http://www
www.trackofthewolf.com
[EMAIL PROTECTED]
-Original Message-
From: Bhavin Vyas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 7:09 PM
To: Nick Boldt; [EMAIL PROTECTED]
Subject: Re: Sort search results by relevance
Are you using FULLTEXT indexes on the search coloumns? They will sort
results
Also, this might help
http://www.mysql.com/doc/F/u/Fulltext_Search.html
- Original Message -
From: "Nick Boldt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 12:49 PM
Subject: Sort search results by relevance
> I have created a se
.
- Original Message -
From: "Nick Boldt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 12:49 PM
Subject: Sort search results by relevance
> I have created a search page which shows all records from a table that
> include one or mor
I have created a search page which shows all records from a table that
include one or more words of the search string. Is there a way I can
have MySQL sort the results according to relevance, and only display
each recordset once?
I am using ASP with IIS 5
txtSearch = Request("txtSearch")
ar
