my $sql = $dbh->exec_select( "select name,account from my_table where name=?", $name );

##</code><code>##

select name,account from my_table where name=Joe