mysql function like oracle isnull

In MySQL, the equivalent function to Oracle's ISNULL is IFNULL. Here is an example:

SELECT IFNULL(column_name, 'default_value') FROM table_name;

This query will return the value of column_name if it is not null, and 'default_value' if it is null.