MySQL Or Condition

Question

Check out this MySQL Query and then I ll show you what I really want it to do     mysql query   SELECT   FROM Drinks WHERE     email   Email      AND date   Date Today      OR date   Date Yesterday      OR date   Date TwoDaysAgo      OR date   Date ThreeDaysAgo      OR date   Date FourDaysAgo      OR date   Date FiveDaysAgo      OR date   Date SixDaysAgo      OR date   Date SevenDaysAgo       The problem with it is that I want it to always match the email  In this case  for example  if the date equals  Date SixDaysAgo then it will be selected from the query even if  Email doesn t equal the email column   So  in short  I want the email to always equal the email column  and if the query pulls a date that equals  Daye TwoDaysAgo or  Date ThreeDaysAgo etc   but doesn t equal the email then don t pull it   I guess my query would look kind of like this  but I m pretty sure it won t work    mysql query       SELECT   FROM Drinks WHERE     email   Email      AND date   Date Today         Date Yesterday         Date TwoDaysAgo         Date ThreeDaysAgo         Date FourDaysAgo         Date FiveDaysAgo         Date SixDaysAgo         Date SevenDaysAgo

User · Answer

Use brackets   mysql query  SELECT   FROM Drinks WHERE email   Email  AND       date   Date Today        OR date   Date Yesterday        OR date   Date TwoDaysAgo        OR date   Date ThreeDaysAgo        OR date   Date FourDaysAgo        OR date   Date FiveDaysAgo        OR date   Date SixDaysAgo        OR date   Date SevenDaysAgo              But you should alsos have a look at the IN operator  So you can say   date IN    date1    date2          But if you have always a set of consecutive days why don t you do the following for the date part  date  lt    Date Today AND date  gt    Date SevenDaysAgo

User · Answer

Wrap your AND logic in parenthesis  like this   mysql query  SELECT   FROM Drinks WHERE email   Email  AND  date   Date Today  OR date   Date Yesterday  OR date   Date TwoDaysAgo  OR date   Date ThreeDaysAgo  OR date   Date FourDaysAgo  OR date   Date FiveDaysAgo  OR date   Date SixDaysAgo  OR date   Date SevenDaysAgo

User · Answer

Use brackets to group the OR statements   mysql query  SELECT   FROM Drinks WHERE email   Email  AND  date   Date Today  OR date   Date Yesterday  OR date   Date TwoDaysAgo  OR date   Date ThreeDaysAgo  OR date   Date FourDaysAgo  OR date   Date FiveDaysAgo  OR date   Date SixDaysAgo  OR date   Date SevenDaysAgo        You can also use IN  mysql query  SELECT   FROM Drinks WHERE email   Email  AND date IN    Date Today    Date Yesterday    Date TwoDaysAgo    Date ThreeDaysAgo    Date FourDaysAgo    Date FiveDaysAgo    Date SixDaysAgo    Date SevenDaysAgo

User · Answer

Your question is about the operator precedences in mysql and Alex has shown you how to  override  the precedence with parentheses   But on a side note  if your column date is of the type Date you can use MySQL s date and time functions to fetch the records of the last seven days  like e g   SELECT     FROM   Drinks WHERE   email   Email    AND date  gt   Now  -Interval 7 day    or maybe Curdate   instead of Now

User · Answer

try this  mysql query   SELECT   FROM Drinks WHERE     email   Email      AND date   Date Today      OR date   Date Yesterday     Date TwoDaysAgo     Date ThreeDaysAgo     Date FourDaysAgo     Date FiveDaysAgo     Date SixDaysAgo     Date SevenDaysAgo                my be like this   OR date   Date Yesterday  oR   Date TwoDaysAgo

[php] MySQL "Or" Condition

Examples related to php

Examples related to mysql

Examples related to select

Examples related to conditional-statements