MySQL optional stored proc parameters

Question

In MSSQL, when I want to ignore an empty filter parameter, I do the following

SELECT * FROM Table WHERE EmployeeName = ISNULL(@EmployeeName, EmployeeName);

How would I achieve this in MySQL?

Answer 1

use coalesce() instead.