Best way to check for NULL in a MySql query

Question

Can someone please let me know how best to use the IF statement in mysql query to show that the "email" field is NULL, then it should display as "no email" ...

Postcode    Telephone             Email
----------------------------------------------------------
BS20 0QN    1275373088         no email
BS20 0QN    1275373088         no email
PO9 4HG 023 92474208        [e-mail]
SO43 7DS    07801 715200       [e-mail]
----------------------------------------------------------

Answer 1

Use the COALESCE function:

COALESCE(Email, 'no email')

Answer 2

Try this way

SELECT * 
FROM table 
WHERE YourColumn IS NULL;

Answer 3

Try IFNULLfunction :

SELECT Postcode, Telephone, IFNULL(Email, "no email")
FROM table