my $thing_query = qq{ SELECT * FROM table WHERE idTable = ? AND some_column = ? AND another_column = ? AND name = ? }; #### my @ary = $dbh->selectrow_array( $thing_query, undef, $table_id, $column_data, $column_info, $name );