Help for this page

Select Code to Download


  1. or download this
    WHERE engine IN (...) AND 'public' IN (settings1, settings2, settings3
    +, settings4)
    
  2. 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
    
  3. or download this
    my $qs = join(",",map('?', @choices));
    my $sql = <<EOF;
    ...
      )
    EOF
    my $rows = $dbh->selectall_arrayref( $sql, {Slice=>{}}, @choices );
    
  4. or download this
    use SQL::Abstract;
    my $sa = SQL::Abstract->new( logic=>'and' );
    ...
        ],
    );
    my $rows = $dbh->selectall_arrayref( $sql, {Slice=>{}}, @bind );