I'm using ASP (VB Script) at the moment for my webpages.
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: RE: Search Engine type search Date: Wed, 23 Aug 2006 16:36:19
-0400 That's a tough one. Basically, you need a spell checker plug-in for
your application
Chris wrote:
The most common next search becomes the did you mean.
Yes, that might work well, but I wouldn't use it out of the box. I would
send a report to a human first to use that information instead of doing
it automatically.
Imagine someone searching for cous (instead of cows) and
]
Sent: Wednesday, August 23, 2006 10:47 PM
To: Jerry Schwartz
Cc: Neil Tompkins; mysql@lists.mysql.com
Subject: Re: Search Engine type search
Jerry Schwartz wrote:
Actually, by default a full text search ignores words that are three
characters or less, not less than three characters.
I found
this to.
Thanks
Neil
Date: Wed, 23 Aug 2006 12:34:10 +1000 From: [EMAIL PROTECTED] To: [EMAIL
PROTECTED] CC: mysql@lists.mysql.com Subject: Re: Search Engine type
search Neil Tompkins wrote: I followed the instructions, but when doing
a search I get no results returned. here is my table
Neil Tompkins wrote:
Thanks for the info. I think that problem was the fact I only had a couple of
records. When creating the FULLINDEX field, does anything else happen to the
field, other than the fact you can search FULLINDEX. The reason I ask is
because I have about 1600 text fields
Actually, by default a full text search ignores words that are three
characters or less, not less than three characters.
I found this out by searching on red.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
One
]; [EMAIL PROTECTED] CC:
mysql@lists.mysql.com Subject: RE: Search Engine type search Date: Wed, 23
Aug 2006 12:18:59 -0400 Actually, by default a full text search ignores
words that are three characters or less, not less than three characters.
I found this out by searching on red. Regards
OK, I appear to be getting somewhere with the FULL TEXT search. Does
anyone have any good resources about producing search engine type results
? for example if some enters a search phrase like londn how would I
suggest the word london ?
Hi Neil,
That's a completely different thing, but
-Original Message-
From: Neil Tompkins [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 23, 2006 4:02 PM
To: mysql@lists.mysql.com
Subject: RE: Search Engine type search
OK, I appear to be getting somewhere with the FULL TEXT search. Does anyone
have any good resources about producing search engine
Jerry Schwartz wrote:
Actually, by default a full text search ignores words that are three
characters or less, not less than three characters.
I found this out by searching on red.
Ahh, oops :) Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Neil Tompkins wrote:
OK, I appear to be getting somewhere with the FULL TEXT search. Does anyone
have any good resources about producing search engine type results ? for
example if some enters a search phrase like londn how would I suggest the
word london ?
I was listening to a podcast
Neil Tompkins wrote:
I have a number of different database fields.
Does anyone have any recommendations about how I can
perform a search engine type search including the text fields.
Full-Text Search:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
cheers,
--renato
--
MySQL
INDEX, but for some reason it is not showing above ?
Any ideas
Neil
Date: Tue, 22 Aug 2006 11:54:43 +0100 From: [EMAIL PROTECTED] To: [EMAIL
PROTECTED] CC: mysql@lists.mysql.com Subject: Re: Search Engine type
search Neil Tompkins wrote: I have a number of different database
fields
On Tue, Aug 22, 2006 at 10:42:52AM +, Neil Tompkins wrote:
On my website I'm looking to add a search box.
I have a number of different database fields. Does anyone have any
recommendations about how I can perform a search engine type search including
the text fields.
Have you
Neil Tompkins wrote:
I followed the instructions, but when doing a search I get no results returned.
here is my table
CREATE TABLE /*!32300 IF NOT EXISTS*/ MyTest ( id int(10) unsigned NOT NULL
auto_increment, title varchar(200) , body text , PRIMARY KEY (id), INDEX
title
15 matches
Mail list logo