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
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 completel
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 ?
> From: [EMAIL PROTECTED]> To: [EMAIL PRO
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
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
--
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.
Regards
Neil
___
Hi All -
I'm building a search engine and what I would like to do is run a search and
get the number of results, but still use the LIMIT command so I am not
returning a ton of rows all at once.
Is this the best way to go about searching?
Thanks,
Matt Babineau
Criticalcode
w:
Hi,
I currently have a table with 2 text fields, both of
which are marked as fulltext. I'm using the full-text
boolean search method with fairly good results.
My problems however are:
1. I am on a shared host provider so I can't tweak
the full-text search options such as stop words or
minimu
Have you tried "explain?" Have you indexed the table?
Curtis
On Sun, 8 Feb 2004, ___bug wrote:
> Hello,
>
>
> What is the best way to search a table with about 500.000 rows of varchar
> type.
> ---
> / id / time / name /
> ---
> Like '%blah%' and x Like '%blu
Hello,
What is the best way to search a table with about 500.000 rows of varchar
type.
---
/ id / time / name /
---
Like '%blah%' and x Like '%blub%' is too slow (takes about 20 sec)
I tried using a fulltext index and search by using MATCH() AGAINST()
The problem
engine
Hi
I'm running a small search engine that indexes the web, but have been having
trouble with optimising it to handle the load.
There are two tables involved in searching - `pages`, which stores the ID,
URL, title and crawl date, and `words` which has two rows - `word` and
`page` where
Jasper Bryant-Greene wrote:
Hi
I'm running a small search engine that indexes the web, but have been having
trouble with optimising it to handle the load.
There are two tables involved in searching - `pages`, which stores the ID,
URL, title and crawl date, and `words` which has two
Hi
I'm running a small search engine that indexes the web, but have been having
trouble with optimising it to handle the load.
There are two tables involved in searching - `pages`, which stores the ID,
URL, title and crawl date, and `words` which has two rows - `word` and
`page` where
Hi All,
say i would like to search for customer, entrying some text
then i would like mysql to return all the customer which id and full name consist of
the text
ex:
IDName
John01John The Junior
Abe01 Abe The Senior
Jo01 Johns The Best
if i enter the criteria 'john' i woul
hi i was wondering what the differences between the 2 servers with search
engine capabilties, also how does the full text indexing actually work ? i
am planning on a footage archive database, it could be titles, but it also
could be content aswell, text in titles are short so should be ok but
WE DELIVER TARGETED UNIQUE SEARCH ENGINE
TRAFFIC TO YOUR WEB SITE
BOTTOM LINE >> IF YOUR POTENTIAL CUSTOMERS
CAN'T FIND YOUR WEB SITE YOU JUST LOST MONEY!
IT'S THAT SIMPLE!
Improving search engine TRAFFIC means:
MORE HITS
MORE BUSINESS
MORE SUCCESS
The most impor
A while ago we chatted about a better MySQL search engine. So I wrote a
script to turn the list into web pages, and indexed these and www.mysql.com
using the alkaline search engine.
the url is http://workinout.com:9998/workinout/search.html
Over time I will add improvements
a. produce
Thx for the correction Paul.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 10:17 PM
To: Vikash K Agarwal; [EMAIL PROTECTED]
Subject: Re: doc storage as BLOB and its search engine on MYSQL
At 16:00 +0530 1/14/03, Vikash K Agarwal wrote
At 16:00 +0530 1/14/03, Vikash K Agarwal wrote:
Hi
We want to create a knowledge base using PHP-MYSQL and if required other
tools like specialized search engine. The knowledge base may consists
for normal text content, HTML content, PDF files, DOC files etc. The
preferred OS is RH Linux 7.3.
My
Hi
We want to create a knowledge base using PHP-MYSQL and if required other
tools like specialized search engine. The knowledge base may consists
for normal text content, HTML content, PDF files, DOC files etc. The
preferred OS is RH Linux 7.3.
My queries are:
1. Should we store these files as
Peavy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 01, 2003 6:08 PM
Subject: Search Engine (text search) like functionality...need to build
> Hello All,
> I have a need to build some user functionality (text search) that is
> similar to the search fun
Hello All,
I have a need to build some user functionality (text search) that is
similar to the search functions available in most search engines. I would
like to have users input a search string and find the appropriate records
in MySql, for example:
database "software development" linux
Part
"Paul Maine" <[EMAIL PROTECTED]>
To: "MySQL MySQL" <[EMAIL PROTECTED]>
Sent: Saturday, July 27, 2002 10:32 PM
Subject: PHP/MySQL Search Engine Query Question
> I am currently working on a website that is implemented using PHP and
MySQL.
>
> The site currently
Pada Sat, 27 Jul 2002 21:32:48 -0500
"Paul Maine" <[EMAIL PROTECTED]> menulis :
> $string ="1972 Ford Mustang"
>
> Using the following SQL statement:
> SELECT * FROM whatevertable WHERE whatevercolumn LIKE '%$search%
> I want to return all records that have Mustang AND 1972 AND Ford.
my sugges
I am currently working on a website that is implemented using PHP and MySQL.
The site currently has a simple search engine that allows a shopper to type
in a search string that is stored in $search. For example, if a shopper
types in 1972 Ford Mustang
$string ="1972 Ford Mustang"
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 chec
D]
Subject: search engine in 3.23.32
I'm running into the problem of word length shorter than 3 characters
not being accepted in this version of FULLTEXT searches. Example at:
http://www.hearth.com/search/index.php (use fuzzy search at bottom)...
I can't recompile now, and also don&
I'm running into the problem of word length shorter than 3 characters
not being accepted in this version of FULLTEXT searches. Example at:
http://www.hearth.com/search/index.php (use fuzzy search at bottom)...
I can't recompile now, and also don't have the technical ability to
create a complica
Hi everyone!
I have a huge database (or will have) and I need to search through it for
web sites. It is a regular Google-Like search engine that returns the web
sites closest to the match, the number of returned queries, etc. Now, what
I want to do is use FULLTEXT or LIKE (preferably FULLTEXT
ED]>
Sent: Thursday, October 18, 2001 12:43 PM
Subject: using a search engine w/ a mysql website
> Hi all-
>
> Sooner or later I'll be in charge of databasing our site (no, it's not
> already databased). That's a good thing, I've really been pushing for it.
> How
Hi all-
Sooner or later I'll be in charge of databasing our site (no, it's not
already databased). That's a good thing, I've really been pushing for it.
However, I'm a bit confused on how to go about searching the site. I'm not
sure if I want to go the "indexing/crawling" route where some app r
Sie schrieben am Mittwoch, 11. Juli 2001, 19:04:42:
> Hi List,
> Can anyone tell me how do i create a search engine
> query.?
> I am new to Mysql and know how to use a simple
> select * from "" where "" = "";
> but what about if I need to
Hi List,
Can anyone tell me how do i create a search engine
query.?
I am new to Mysql and know how to use a simple
select * from "" where "" = "";
but what about if I need to
create a query for a search engine that looks for Every word.
Thanks in Advance
Prad
Hi all,
I have been using Mysql to power my online database search engine(CGI). IT contains
more than 500K rows of records(12 columns).
Is there a trick to optimize Mysql Table( by using Index , temporary table??) so that
the search engine could get the result in
shorter time?
Should I
Hi,
You are right about this, I should have thought about it. There is just
one problem: A word can occur multiple times in the same documents, so the
table which gives the position of a word in a doc. must give all the
positions of the word. If we keep your logic, we would have to make a tab
educating, articles here too.)
http://www.ping.be/~ping0658/avrank.html#zipf
http://www.swtech.com/server/websvr/wsindex/
Regards,
Sander
> -Original Message-
> From: Cedric Veilleux [mailto:[EMAIL PROTECTED]]
> Sent: 23 March 2001 04:30
> To: [EMAIL PROTECTED]
> Subject: Larg
st for example!)
btw: your email address looks like "postmaster", is this a bug in the lists
or are you subscribed as postmaster?
regards,
rene
- Original Message -
From: "Cedric Veilleux" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, Mar
Hi,
I am planning a very large search engine. I've spent some time reading
the archive and I found some suggestions on how to do this. The word
indexing method is a very interesting alternative to slow "...where like
'%foo%';" queries.
There is from 100k to 500k doc
Dear Software Manufacturer:
We can help you make it much easier to promote your software on the Internet.
Your company is invited to list its software products at no charge on BigSoftE, the
first Internet Software Search Engine. Launching this month, Bigsofte provides
detailed product
Hey guys, I've got a question regarding a search engine I have to write
Basically what I have is this.. This is for a web page BTW.
I have a table with a TEXT field in it. I'd like to take that field
and search for keywords... I've got a mySQL database and this is how I'm
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
f links to other, very interesting, papers.)
>
> 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/m
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 rig
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 poin
Could anyone point me to any documents on creating a search engine using
MySQL or search engine theory in general?
Thanks,
Jamie Krasnoo
www.MyEBoard.com
[EMAIL PROTECTED]
PGP Key - http://www.planetphat.com/jkrasnoo/pgp.html
Dear Marketing Manager:
BigSoftE is pleased to invite to list its software products for FREE on the world's
first Internet Software Search Engine. We encourage you to join nearly 10,000
software companies who are making it simple to attract software prospects on the
Internet. Listi
into a slot and expect it is going to do what
you want. If you have ever explored college websites, you might
notice that most are large affairs that often have a lot of
disjointed and poorly organized pages. Most try to solve bad
organization with a stock search engine like ht://Dig or Ultr
As I understand it, search engines use a "special" type of database
structure.
They have a special table for common words/phrases and another one with all
the data.
They link theese together by a third one that contains only the id´s from
the other two, thus making the search much faster.
How do t
58 matches
Mail list logo
