Computer Exploded!!!
| From: | Selvin Sakal | Date: | Tue, 01 May 2001 06:17:51 +0000 |
| Subject: | Computer Exploded!!! | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9009@lists.php.net to get a copy of this message | ||
My computer didn't explode i just wrote that to get attention. My question is this - I have 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.