my $colname= 'city'; my $value= 'Toledo'; #### select * from mytable where city = 'Toledo'; #### my $sth= $dbh->prepare("select * from mytable where ? = ?"); ... $sth->execute( $colname, $value ); #### select * from mytable where 'city' = 'Toledo';
## select * from mytable where city = 'Toledo'; ##
## my $sth= $dbh->prepare("select * from mytable where ? = ?"); ... $sth->execute( $colname, $value ); ##
## select * from mytable where 'city' = 'Toledo';