SELECT..INTO...NO_DATA_FOUND and TOO_MANY_ROWS

[Paul van Keulen]

Hi,
I've worked several years with Oracle, now I'm into mysql.
In Oracle I've got the situation:

Begin
SELECT author_last_name
INTO v_authName
FROM authors
WHERE author_state = v_auth_state;

// work with v_authname
When NO_DATA_FOUND
// do something
When TOO_MANY_ROWS then
// do something
END;

How can I translate (SELECT..INTO...NO_DATA_FOUND and TOO_MANY_ROWS) above situation to MySql?

Regards,
Paul