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';