Look at the selectrow_*, selectcol_* and selectall_* methods in DBI (perldoc DBI)
In reply to Re: Simpler DBI::MySQL queries by edan in thread Simpler DBI::MySQL queries by Cody Pendant