How to write the right query for one table?

Question

SQL

There is a table with users:

id | from_id | to_id
-----------------
1  | 20      | 32
2  | 76      | 10

Input data - 2 variables, they can come in this form - ( 32, 20 ) or in this form - ( 20, 32 )

What query can be made to get the correct string at the output?

Answer 1

well let's say this:

select *
from `table_name`
where (from_id = 32 and to_id = 20)
   or (from_id = 20 and to_id = 32)
limit 1;

Just keep in mind that if there are two entries in the table: 32.20 and 20.32, then it is not possible to determine which of them is correct based on the input data.