my $sth = $dbh->prepare("select column from ? where column = ?");

my $table = 'foo';
my $value = 'bar';
$sth->execute($table, $value);