MySQL OR question.

Question

Is there a way I can use the OR or something similar inside a join, inside the mysql code below.

INNER JOIN users_friends ON users.user_id = users_friends.friend_id OR users_friends.user_id

Answer 1

INNER JOIN users_friends
    ON users.user_id IN (users_friends.friend_id, users_friends.user_id)

Answer 2

try:

INNER JOIN users_friends ON (users.user_id = users_friends.friend_id OR users_friends.user_id)

Answer 3

Don't you mean...

INNER JOIN users_friends ON (users.user_id = users_friends.friend_id OR
                             users.user_id = users_friends.user_id)