check for NULL value in MySql query

Question

Can any one please let me know the best way to use IF statement in mysql query to show if the "email" field is NULL then it should show as "no email"...

Postcode    Telephone             Email
----------------------------------------------------------
BS20 0QN    1275373088         no email
BS20 0QN    1275373088         no email
PO9 4HG 023 92474208        prabhu1@vacmedia.com
SO43 7DS    07801 715200       test@vacmedia.com
----------------------------------------------------------

Answer 1

Use the COALESCE function:

COALESCE(Email, 'no email')