Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re: SQLite and large number of parameters

by moritz (Cardinal)
on Dec 10, 2012 at 11:53 UTC ( #1008090=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download

  1. or download this
    my $sql = sprintf q[
    SELECT *
       col_1 IN (%s) AND
       col_2 IN (%s)
    ], join(', ', @$set_1), join(', ', @$set_2);