Re: DBI select IN Array

Use the pram/baby cart, young Jedi!

my @tagList=('red','black');
my $sql="SELECT table FROM tags WHERE tag IN (@{[join(', ', ('?') x @t
+agList)]})";
print $sql,"\n";
[download]

yields

SELECT table FROM tags WHERE tag IN (?, ?)
[download]

Comment on Re: DBI select IN Array Select or Download Code

Replies are listed 'Best First'.
Re^2: DBI select IN Array by Tux (Canon) on Feb 20, 2019 at 15:41 UTC
Or use `$"`: `local $" = ","; my $sql = "select table from tags where tag in (@{[('?')x@taglist]})";` [download] Enjoy, Have FUN! H.Merijn	[reply] [d/l] [select]