As far as I know SQLite doesn't support anything like that.

The syntax is standard for libraries that implement bound parameters (and prepared statements that use them), but you would need to do that in a programming language that queries the database, and not in the database itself.

The specifics, of course, depend on the programming language and the library.

In Perl, for example you could:

my $sth = $dbh->prepare("Select * from t2 where value= ?"); foreach my $value (@values) { $sth->execute($value); $row = $sth->fetchrow_hashref; [...] } 

Bobby Tables has some more examples in a variety of languages.

As far as I know SQLite doesn't support anything like that.

The syntax is standard for libraries that implement bound parameters (and prepared statements that use them), but you would need to do that in a programming language that queries the database, and not in the database itself.

The specifics, of course, depend on the programming language and the library.

In Perl, for example you could:

my $sth = $dbh->prepare("Select * from t2 where value=?"); foreach my $value (@values) { $sth->execute($value); $row = $sth->fetchrow_hashref; [...] } 

Bobby Tables has some more examples in a variety of languages.