$all = $dbh->selectall_arrayref("SELECT ID, col1, col2 FROM table WHERE col1 = 'xxx'"); print "Number of rows selected: $all ";