delete column from select * [duplicate]

I have an api that returns the user's data in json, but wanted to return all the data except the password, would it have some way without being select in all fields except the password? I'm currently doing this:

    if ($autenticado) {
    $resultado = $sql->select("SELECT * FROM tb_alunos WHERE email = :EMAIL LIMIT 1",array(
        ":EMAIL"=>$usermail[0]
    ));
    $response = json_encode($resultado);
}else{
    return $response->withStatus(401);
}