How to select records from a table by two parameters?

Question

MySQL

There is a base `test`
id -- from -- to
1 -- 2 -- 1
2 -- 5 -- 1
3 -- 1 -- 2
4 -- 5 -- 9
5 -- 5 -- 13
6 -- 20 -- 21
7 -- 67 -- 1
how to get all records where from or to = 1? Y get the difference from them, i.e. get:
2, 5, 67

Answer 1

how to get all records where from or to = 1?

or
if you do it like this...
then we will get no records, since there is no record in which to and form contain 1
You can, of course, use the conditions by which to determine which column to display data ...