my $sth = $dbh->prepare('SELECT foo, bar, baz FROM ? WHERE ...'); $sth->execute('blah'); #### my $sth = $dbh->prepare('SELECT foo, bar, ? FROM blah WHERE foo = 1 AND bar = 2'); $sth->execute('baz');