I like this:
but;

#!/usr/bin/perl
    use strict;
    use warnings;
    use DBI;

    # Connect to the database, (the directory containing our csv file(
+s))

    my $dbh = DBI->connect("DBI:CSV:f_dir=.;csv_eol=\n;");

    # Associate our csv file with the table name 'prospects' and
    # manually declare names for each of the columns

    $dbh->{'csv_tables'}->{'prospects.csv'} = {
            'col_names' => ["name", "address", "floors", "donated", "c
+ontact"]
    };

    # Output the name and number of floors using our column names

    my $sth = $dbh->prepare("SELECT * FROM prospects.csv WHERE name LI
+KE 'G%'");
    $sth->execute();
    while (my $row = $sth->fetchrow_hashref) {
        print("name = ", $row->{'name'},
              ",   Number of floors = ", $row->{'floors'}, "\n");
    }
    $sth->finish();
[download]

This code is from "http://perlmeme.org/tutorials/parsing_csv.html". But running it gives this:

DBD::CSV::st execute failed: Error 2034 while reading file /media/Micr
+oSD/code/prospects.csv: EIF - Loose unescaped quote at /usr/local/sha
+re/perl/5.14.2/SQL/Statement.pm line 1055
 [for Statement "SELECT * FROM prospects.csv WHERE name LIKE 'G%'"] at
+ propects.pl line 20.
DBD::CSV::st fetchrow_hashref failed: Attempt to fetch row without a p
+receeding execute () call or from a non-SELECT statement [for Stateme
+nt "SELECT * FROM prospects.csv WHERE name LIKE 'G%'"] at propects.pl
+ line 21.
[download]