my @search = qw/%this% %that%/;
   my $sql = "select something from table where column1 like ? or column2 like ?";
   my $sth = $dbh->prepare( $sql );
   $sth->execute( @search );