MySQL conditions

Discussion in 'Programming' started by dargre, Apr 1, 2007.

0
  1. #1
    Let's say I have a query:
    I wish to run 'CC=z' condition only if AA=x.
    Is there a way to do it in one query?
     
    dargre, Apr 1, 2007 IP
  2. TwistMyArm

    TwistMyArm Peon

    Messages:
    931
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I would say you're after:
    $sql = "SELECT * FROM TABLE WHERE (AA = x AND CC = z) OR BB = y ORDER BY DD";

    instead.
     
    TwistMyArm, Apr 1, 2007 IP