MYSQL Select row if value found in any column of a particular table

Question

I am trying to fetch all rows from a particular table if value found in any column of the particular table.

Answer 1

you can just use IN. eg

SELECT *
FROM tbName
WHERE yourValue IN (column1, column2, column3, ....)