Why not start with the table of contents.
I might have been more helpful, but
I don't think trying to cover "lazy" with "cute" is a good approach to life.
Ravi Raman wrote:
> hi.
>
> a link to the relevant section of the manual might be more helpful.
> http://www.mysql.com/doc/F/u/Fulltext_Search.html
>
> -ravi.
>
> -----Original Message-----
> From: Gerald Clark [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 9:25 AM
> To: Selvin Sakal
> Cc: [EMAIL PROTECTED]
> Subject: Re: Computer Exploded!!!
>
>
> 1. Read the manual
> 2. Read the manual
> 3. get a book on SQL
>
>
> Selvin Sakal wrote:
>
>
>> My computer didn't explode i just wrote that to get attention. My question
>> is this - I have a database with a table which looks like this -
>>
>> CREATE TABLE sites
>> (
>> ID INT NOT NULL AUTO_INCREMENT,
>> name VARCHAR(30) NOT NULL,
>> keywords VARCHAR(200) NOT NULL DEFAULT 0,
>> description VARCHAR(200) NOT NULL DEFAULT 0,
>> url VARCHAR(50) NOT NULL,
>> rank blob NOT NULL,
>> PRIMARY KEY (ID)
>> );
>>
>> there is a index on keywords and description
>>
>> what i would like to know is how to search description to see if it
>> contains a word like 'web'.
>>
>> i would also like to know how to search description and keyword for
>> specific
>> words like this -
>>
>> say description has 'the best search engine on the net'
>>
>> i want to search for all the descriptions that contain 'best' and 'net'.
>>
>> If i don't get help soon my computer might explode.
>>
>> _________________________________________________________________________
>> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>>
>>
>> ---------------------------------------------------------------------
>> 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
>
>
>
> --
> Gerald L. Clark
> [EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> 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
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
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