List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:May 1 2001 1:24pm
Subject:Re: Computer Exploded!!!
View as plain text  
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 <mysql-thread72760@stripped>
> To unsubscribe, e-mail 
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
Computer Exploded!!!Selvin Sakal1 May
  • Re: Computer Exploded!!!Gerald Clark1 May
    • RE: Computer Exploded!!!Ravi Raman1 May
      • Re: Computer Exploded!!!Gerald Clark1 May
    • Re: Computer Exploded!!!AJDIN BRANDIC1 May