How can you test all arrays for common values?

Question

PHP

There is a base
id = auto
idcontact1
idcontact2
status
It is necessary to display all records that have a pair according to this principle status = 1 and id (our = 2) is in both the first and second columns, and at the same time any id is in both line (if there is a pair according to this principle-> friends, there is no pair-> subscriber

Answer 1

SELECT * FROM TABLE WHILE (idcontact1 = 2 OR idcontact2 = 2) AND status = 1