my @searchs = qw(Tom Test); my @veranstalter = map{'veranstalter LIKE '.$_}@searchs; my @beschreibung = map{'beschreibung LIKE '.$_}@searchs; my $statement = 'SELECT * FROM event_topic WHERE ('.join(' OR ',@veranstalter).') AND ('.join(' OR ',@beschreibung).') ORDER BY time;'; my $sth = $dbh->prepare($statement); $sth->execute(); while(my @array = $sth->fetchrow_array()){  print "@array"; } $sth->finish();