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.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to