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
ROTECTED]
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 character
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")
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 a
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 unsubsc
.8796 / FAX: 860.674.8341
-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 abou
> 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, b
TECTED]; [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.> >
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
On
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 whic
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 sea
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 (title,body));
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
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 ha
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
Hi Frank,
the full text search from MySQL is probably what you are looking for. You
can read more about it in the online documentation.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Ful
ltext_Search
Cheers,
Pieter
- Original Message -
From: "Frank Peavy" <[E
On Mon, 2002-06-17 at 22:06, Deependra B. Tandukar wrote:
> Greetings !
>
> I need to develop a search engine for my site. I would be grateful if anyone
> could pass me any reference.
>
> Thank you.
Hi Deependra!
This question is asked fairly often. Please check the mailing list
archives
Use the php function 'explode' to seperate words based on spaces into an
array, and then go through your list checking the length of each word.
Chris
-Original Message-
From: Craig Issod [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 10:44 PM
To: [EMAIL PROTECTED]
Subject: s
I don't know if I understand your question, but you may want to
SELECT * FROM table
WHERE fieldname LIKE '%searchterm%'
Also, search at mysql.com for FULLTEXT in
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
and learn what you can do with this and when this will be good.
Sie schrieben
Hi,
On Wed, 28 Feb 2001, Sander Pilon wrote:
> Web robots are not search engines (just the things that fill the engines),
> as far as I understand.
Yes, you are right. I do know the difference between them too. I just
missred the letter. (Yes, I should first read and then write) Anyway, the
docs
Web robots are not search engines (just the things that fill the engines),
as far as I understand.
As I mailed to J. earlier, most searchengine algorithms aren't directly
compatible with (my)sql.
(Meaning that, for the best performance *you* have to do the searching, and
not mysql - once you have
Hi Jamie,
On Tue, 27 Feb 2001, Jamie Krasnoo wrote:
> Could anyone point me to any documents on creating a search engine using
> MySQL or search engine theory in general?
Try this one: http://info.webcrawler.com/mak/projects/robots/robots.html
I am writing a mySQL based search engine right now, a
http://www.google.com/search?q=search+engine+theory ;)
--jfarr
- Original Message -
From: "Jamie Krasnoo" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 2:25 PM
Subject: Search Engine Theory
> Could anyone point me to any documents on creating a s
Most search engines use databases. Some search directories or web
addresses directly. Some use spiders to collect data. Search engines
are as varied as the kinds of jobs they do. First, decide what needs
to be searched and what searched for. Then research it. Don't just
plug a stock program into a
24 matches
Mail list logo
