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
