my $sql = "SELECT DISTINCT id FROM mytable WHERE open = ?";
my $ref =  $dbh->selectall_arrayref($sql,undef,'true');
@id = map{ $_->[0] } @$ref;
die join (", ", @id), "\n";