Getting a single hash from a row in a MySQL query

Hi, all. Right now, when I want to pull a hash out of a database, I find myself first pulling all matching rows from my select, then iterating through all the hashes in a given row. Surely, when I've got a row, I should be able to say something akin to
puts row["foo"]
and have it spit out its value, "bar", instead of doing what I am right now, which is

row.each_pair do |key, value|
    stuff happens here
end

Pointers? (And apologies if this is a totally newb kind of question...)

Thanks!

-Ken

···

--
This mail was scanned by BitDefender
For more information please visit http://www.bitdefender.com/links/en/frams.html

results.each do |row|
    puts row['name']
  end

···

--
Posted via http://www.ruby-forum.com/.