my $dbh = DBI->connect( "dbi:SQLite:$our_db" ) || die "Cannot connect: $DBI::errstr"; my $all = $dbh->selectall_arrayref("SELECT ID, value1, value2 FROM table WHERE value1 = '$query'");