5 Einträge, 1 Seite |
WHERE ( (id = ? AND user = ?) OR (birthday = ? AND gender = ?) )
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
#!/usr/bin/perl use strict; use warnings; use lib qw(./lib); use SQL::Abstract; my $sql = SQL::Abstract->new; # WHERE ( (id = ? AND user = ?) OR (birthday = ? AND gender = ?) ) my %where = ( -or => [ { id => '1', user => 'hallo', }, { birthday => '12.01.1999', gender => 'm', } ], ); my ($stmt) = $sql->select('tabelle', [qw/a b c/], \%where); print $stmt;
5 Einträge, 1 Seite |