in reply to Simpler DBI::MySQL queries
Look at the selectrow_*, selectcol_* and selectall_* methods in DBI (perldoc DBI)