How to make an sql query for several matches in different fields of the same table?

Question

SQL

How to make an sql query for several matches in different fields of the same table? we have 5 fields of the table, we need to make a selection if some SEVERAL values ​​match

Answer 1

SELECT * FROM `table` WHERE
      `field1` IN ('1', '2', '3')
      AND `field2` IN (6, 7, 8)
      AND 'field3' IN ('000-888')
      AND `field4` IN ('mama', 'papa', 'baba')
      AND 'field5' IN ('yes', 'ok', 'on')