No, because you need to put commas and quotes there:

my $sql = "SELECT id, order_num, state FROM orders WHERE names IN (".j
+oin(",",map($dbh->quote($_), @names)).")";
[download]

Where $dbh is your DBI database handle. See also map , join and DBI's quote() method.