MySQL Update query using a combination xy or yx

Question

I know the question is little ambiguous. I hope I am able to clarify the question here.

I have a table,Table Name: user_group_relation

|--------------------------------------|
| userId | userId_1 | groupId | amount |
|--------------------------------------|
|   3    |     5    |     1   |  0.00  |
|--------------------------------------|

I want to issue a update on the table, so as I have two columns userId and userId_1 which have the userId of two different users.

I have a relation (3,5) is there any way I can look up in the table for this combination where the relation (userId_1, userId) could have been stored as either (3,5) or (5,3)

Monkey Supersonic · Accepted Answer · 2016-01-11 21:00:30Z

1

Do you mean

SELECT * FROM user_group_relation WHERE (userId_1 = 3 AND userId = 5) 
OR (userId_1 = 5 AND userId = 3);

or

UPDATE user_group_relation set userId_1 = <value>, userId = <value> 
WHERE (userId_1 = 3 AND userId = 5) OR (userId_1 = 5 AND userId = 3);

?

answered Jan 11, 2016 at 21:00

Monkey Supersonic

1,2721 gold badge11 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gautam Sawala Over a year ago

Yes, exactly! That was what I wish to do! Thanks for the answer!

Collectives™ on Stack Overflow

MySQL Update query using a combination xy or yx

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related