Question by anfuller
I have two columns of data
Refer > Target 1 > 4 1 > 7 2 > 5 3 > 6 4 > 1
I want to run a query in MySQL that selects every refer that is also selected by its target. So, 1 > 4 and 4 > 1.
The furtherest I can get is:
SELECT refer FROM table WHERE refer IN (SELECT target FROM table)
But that just lists what is in the other column, not what’s matching.
Answer by Starx
I dont think there is a need to over complicate this query
SELECT refer FROM TABLE WHERE (refer = '1' and target = '4') or (refer ='4' and target = '1')