AND OR statement

[owner]

Is there an AND OR type of statement in mySQL where if you select two fields you can sort them like: WHERE field=1 AND OR field2=1

 

That way if both fields matched it would be much more specific than just one field matching.

 

Thanks!

owner

[ahs10]

i'll try to help, just cuz i'm hanging out seeing if anyone will initially bite on my question.  i think the best help i can give you is to tell you that it is unclear what you are asking in your post.  you need to rephrase your question and providing an example query (the full query, not just the where clause) would prolly help too.  finally, although you question isn't affected by version so much... they are really anal about that here, so post your mysql server version too.  when in rome......

 

now "AND" and "OR" are both operators in sql.  you would use "AND" to match more than one statement and you would use "OR" to match just one statement.  so an attempt at helping you out, pay attention to the brackets... it's structured query language, it should make sense....

 

SELECT * FROM `database`.`table` WHERE (`field` = 1 AND `field2` = 1) OR (`field` = 2 AND `field2` = 2)

 

this would match rows where field and field2 both equal 1

it would also match rows where field and field2 both equal 2

[owner]

Well what I am trying to say is if the first where statement is true and finds a specific match, don't do the or statement.    If their was not a match then do the or statement.

 

Is that possible?

owner

[roopurt18]

WHERE
    CONDITION_A OR
    ( NOT CONDITION_A AND CONDITION_B )