SELECT *, URL FROM google WHERE q = "perl monks" LIMIT 1 #### $VAR1 = { 'cached_size' => '', 'snippet' => '', '_u_r_l' => '', 'summary' => 'Contains tutorials, discussion forums, Perl poetry, obfuscated code, and a large code repository.', 'directory_category' => '', 'url' => 'http://www.perlmonks.org/', 'host_name' => '', 'title' => '', 'directory_title' => '' }; #### SELECT * FROM google WHERE q = "perl monks" LIMIT 1 #### $VAR1 = { 'cached_size' => '', 'snippet' => '', '_u_r_l' => '', 'summary' => 'Contains tutorials, discussion forums, Perl poetry, obfuscated code, and a large code repository.', 'directory_category' => '', 'host_name' => '', 'title' => '', 'directory_title' => '' }; #### use DBI; use strict; use Data::Dumper; my $KEY = "See http://www.google.com/apis/ to get a key."; my $dbh = DBI->connect("dbi:Google:", $KEY) or die("Can't connect to DB: " . $!); my $sth = $dbh->prepare(qq[ SELECT *, URL FROM google WHERE q = "perl monks" LIMIT 1 ]) or die("Can't prepare query: " . $!); $sth->execute() or die("Can't execute query: " . $!); while (my $r = $sth->fetchrow_hashref) { print Dumper($r), "\n"; }