You can use LIKE and wildcards, which is faster than fulltext searches, which will provide you a lot of information you don't need. Do this: SELECT * FROM table where column LIKE "%politics%" OR column LIKE "%local%" to find if the field contains politics or local.. -Micah On Tuesday 21 June 2005 05:49 pm, Tramelw@xxxxxxx wrote: > 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
