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.. 


On Tuesday 21 June 2005 05:49 pm, [EMAIL PROTECTED] 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.
> 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 (
To unsubscribe, visit:

Reply via email to