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 can I achieve this in MySQL?

0

ProfK 13 nov. '08 at 16:25

1 answer

longneck · Accepted Answer · 2008-11-13T16:31:06+0000

You can use instead coalesce()

.