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 search page which shows all rec
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.
