$sth->prepare_cached("SELECT * from t where id = ?"); $DBH->selectall_arrayref($sth, {}, @bind_values);