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 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
