Help for this page

Select Code to Download


  1. or download this
    SELECT * FROM some_table WHERE key IN ( ?, ?, ?);
    
  2. or download this
    my @searchkeys = qw(a b c d);
    my $query = qq{
    ...
        . join(",", map( {$dbh->quote($_)} @searchkeys))
        . qq{)};
    
  3. or download this
    #!/usr/bin/perl -w
    use DBI;
    ...
    Benchmark: timing 2000 iterations of in, or...
        in: 17 wallclock secs ( 0.30 usr +  0.10 sys =  0.40 CPU)
        or: 95 wallclock secs ( 0.41 usr +  0.06 sys =  0.47 CPU)