- or download this
WHERE engine IN (...) AND 'public' IN (settings1, settings2, settings3
+, settings4)
- or download this
my $engines = join(",",map($dbh->quote($_), @choices));
my $sql = <<EOF;
...
settings1="public" OR settings2="public" OR settings3="public"
+OR settings4="public"
)
EOF
- or download this
my $qs = join(",",map('?', @choices));
my $sql = <<EOF;
...
)
EOF
my $rows = $dbh->selectall_arrayref( $sql, {Slice=>{}}, @choices );
- or download this
use SQL::Abstract;
my $sa = SQL::Abstract->new( logic=>'and' );
...
],
);
my $rows = $dbh->selectall_arrayref( $sql, {Slice=>{}}, @bind );