This is a new area for me, so it may sound like a stupid question, but what do you mean by FULLTEXT indexes?
P.S. the field I am searching is of VARCHAR type. Nick Boldt Computer Network Administrator Track of the Wolf Elk River, MN 55330 Tel: 763-633-2500 Fax: 763-633-2550 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 according to relevance (depending upon the algorithm, that might not be what you want). It will index most of the relevant words in your column (which should be a TEXT or a VARCHAR field) and then search on those words. ----- 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 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") > arrSearch = split(txtSearch, " ") > tmpSearch = "" > For x = 0 To UBound(arrSearch) > If x <> 0 Then > tmpSearch = tmpSearch & "or " > End If > tmpSearch = tmpSearch & "us_desc LIKE '%"& arrSearch(x) &"%'" > Next > > searchString = "SELECT * FROM consign WHERE consign_num = > '"&prodRs("consign_num")&"' AND ("& tmpSearch &") ORDER BY consign_num > ASC" > > Thanks in advance for any help you can provide. > > Sincerely, > > Nick Boldt > Computer Network Administrator > Track of the Wolf > Elk River, MN 55330 > Tel: 763-633-2500 Fax: 763-633-2550 > www.trackofthewolf.com > [EMAIL PROTECTED] > > > > > > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
