my $joiner = $select_any ? ' or ' : ' and '; my $where = join $joiner, ('bodytext like ?') x @terms; $where .= " order by id desc"; my @terms = map { "%$_%" } @terms; my $sth = $db->prepare("$querystr $where"); $query->execute(@terms);