use full text searches
http://dev.mysql.com/doc/mysql/en/fulltext-search.html
bastien
From: Tramelw@xxxxxxx
To: php-db@xxxxxxxxxxxxx
Subject: select * from table where column 'CONTAINS' more than one
value (how?)
Date: Tue, 21 Jun 2005 20:49:12 EDT
Hello all,
I have no problem creating a table, using a query from my dbase table
"news":
SELECT * FROM table where column = VALUE.
However, now that most of our articles have more than one column type (i.e.
instead of just technology, the column can now contain "technology,
politics,
local".
My question is now that I have more than one value, what format can I use
for a "contain" command.
EXAMPLE:
articles needed "local political" articles:
SELECT * FROM table where column contains "politics", "local".
Does anyone know how to format the above command into a proper SQL query
language?
Thank you in advance.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
