[SOLVED] Is there a MySQL 'OR' statement?

[sorenchr]

Hi, I'm using the following query:

 

SELECT id 
  FROM home_friends 
WHERE friend_alpha = '1'
    AND friend_beta = '16' 
LIMIT 1

 

The friend_alpha and friend_beta represents a connection between to users. Meaning, user 1 is friends with user 16, and vice versa. However, the same situation could appear with the user id's reversed(alpha=16, beta=1). So im looking for a kind of 'OR' statement, to detect if the reverse situation is true. Sort of like this:

 

SELECT id 
  FROM home_friends 
WHERE (friend_alpha = '1'
    AND friend_beta = '16')
      OR (friend_alpha = '16'
    AND friend_beta = '1')
LIMIT 1

 

So does anything like this exist?

[revraz]

Did you try it?

[sorenchr]

Did you try it?

 

Dear god...

 

Thank you.

[revraz]

lol no problem