mysql search 2 columns single value code example

Example: sql server check for value in multiple columns

SELECT * FROM table WHERE 123 IN(col1, col2, col3, col4);