How to do multi-column search in SQL?

Question

PHP

There is a field (input type="search" name="search"). I have a table with five columns.
How to find an entry, for example, in the second column and in the third?
Tried like this:

Select * from `table` where `colum3` & `column2` Like '%$search%'

Gives out zero.
Option 2

Select * from `table` where `colum3` AND `column2` Like '%$search%'

This code works, but for some reason it doesn't find the number!

Answer 1

Got it right:

Select * from `table` where `colum3`  Like '%$search%' OR `column2` Like '%$search%'

Answer 2

select * from table where column2 = $search
union
select * from table where column3 = $search