On Thu, Apr 26, 2001 at 09:54:56AM +0200, [EMAIL PROTECTED] wrote:
> we're just facing a "challenging" problem ... we have a MySQL lessons
> learned database. In two fields of the main table (LONGTEXT) we have the
> "description" and the "solution".  You could think of two short abstracts,
> regarding the lesson (some 100 words or more).
> 
> We need to implement a search engine, which should search in some
> indexed fields as well as inside the two texts, contained in the two
> LONGTEXT fields "description" and "solution".
> 
> We do not have any idea on how to implement such a wonderful toy
> (we've never faced the problem before). Could You help us?

Look at the fulltext indexing feature in the latest versions of
MySQL. It may be what you need.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878    Fax: (408) 530-5454
Cell: (408) 439-9951

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

Reply via email to