Re: SELECT query with multiple "WHERE" Clause
| From: | Greg Bowser | Date: | Thu, 28 Feb 2008 00:08:40 +0000 |
| Subject: | Re: SELECT query with multiple "WHERE" Clause | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44683@lists.php.net to get a copy of this message | ||
In MySQL, both "OR" and "||" are valid logical or operators. You can only
have one Where clause, thus your last example is correct.
--GREG
On Wed, Feb 27, 2008 at 6:44 PM, Nasreen Laghari <nasreen_laghari@yahoo.com>
wrote:
> Hi All,
>
> Thank you for increasing my knowledge about PHP/MYSQL.
>
> I am creating a SEARCH, by only using one table. The search form is same
> as Inserting item (search has form of all fields in table ), difference is
> SEARCH page doesnt have validation . Therefore user can enter information in
> any of field. I would like to know how to write a SELECT query which has
> multiple where clause with OR operator.
>
> shall we write:
>
> $query = mysql_query("SELECT * from gig WHERE Name='$name' || WHERE
> gig_fdate='$sdate'");
>
> OR
>
> $query = mysql_query("SELECT * from gig WHERE gigName='$gig_name' OR WHERE
> gig_fdate='$sdate'");
>
> OR
>
> $query = mysql_query("SELECT * from gig WHERE gigName='$gig_name' ||
> gig_fdate='$sdate'");
>
>
> Regards
>
> Nasreen
>
>
>
> ____________________________________________________________________________________
> Looking for last minute shopping deals?
> Find them fast with Yahoo! Search.
>
> http://tools.search.yahoo.com/newsearch/category.php?category=shopping
>