OR kullanarak yapabilirsiniz.


$query = $dbh->prepare('SELECT * FROM table WHERE sutun1 LIKE ? OR sutun2 LIKE ? OR sutun3 LIKE ?');
$query->execute(array("%$deger1%","%$deger2%",.....));