RE: [PHP-DB] select * from table where column 'CONTAINS' more than one value (ho
| From: | Bastien Koert | Date: | Wed, 22 Jun 2005 00:54:21 +0000 |
| Subject: | RE: [PHP-DB] select * from table where column 'CONTAINS' more than one value (ho | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39732@lists.php.net to get a copy of this message | ||
use full text searches
http://dev.mysql.com/doc/mysql/en/fulltext-search.html
bastien
From: Tramelw@aol.com To: php-db@lists.php.net Subject: [PHP-DB] 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.