$query = "SELECT * FROM `table` WHERE colum1 LIKE '%$searchfor1%' OR colum2 LIKE '%$searchfor2%' OR colum3 LIKE '%$searchfor3%' OR colum4 LIKE '%$searchfor4%'";
$sql = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_row($sql))
{
(tuka izkarwash rezultata) echo $row[columname1]
}