$sql = "select "; $joiner = " "; foreach (@enable_opts) { $sql .= $joiner . $_ . "(column)"; $joiner = ","; } $sql .= " from table where column = ?"; #etc