COLA,COLB,VALUE foo,bar,1 baz,bar,2 #### #!/usr/bin/perl use strict; use warnings; use DBI; use Data::Dumper; my $dbh = DBI->connect(qq{DBI:CSV:f_dir=.;csv_eol=\n}, undef, undef, {RaiseError => 1}); my $sth = $dbh->prepare('SELECT VALUE FROM MyTable WHERE COLA = ? AND COLB = ?'); $sth->execute('baz', 'bar'); my @r = $sth->fetchrow_array(); print Dumper \@r; #### $ perl ./csvtest.pl $VAR1 = []; #### $ perl ./csvtest.pl $VAR1 = [ '1' ]; #### $ perl -MDBI -e 'DBI->installed_versions' Perl : 5.008008 (i686-linux-thread-multi) OS : linux (2.6.16-gentoo-r12) DBI : 1.58 DBD::mysql : 4.005 DBD::Sponge : 12.008696 DBD::SQLite : 1.13 DBD::Proxy : 0.2004 DBD::Multiplex : 1.98 DBD::Gofer : 0.009560 DBD::File : 0.35 DBD::ExampleP : 12.009532 DBD::DBM : 0.03 DBD::CSV : 0.22 $ perl -MSQL::Statement -le 'print $SQL::Statement::VERSION' 1.15 $ perl -MText::CSV_XS -le 'print $Text::CSV_XS::VERSION' 0.32