Re: select * from table where column 'CONTAINS' more than one value (how?)
| From: | Micah Stevens | Date: | Wed, 22 Jun 2005 02:10:16 +0000 |
| Subject: | Re: select * from table where column 'CONTAINS' more than one value (how?) | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39733@lists.php.net to get a copy of this message | ||
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@aol.com 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.