Best way to check for NULL value in MySql query -

Best way to check for NULL value in MySql query -

January 15, 2010

Can anyone please tell me the best way to use the IF statement in the mysql query, what is the "Email" field Tap should not show this "no email" ...

  Postal code 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 ------------------------------------ - --------------------

Use COALESCE function:

  COALESCE (email, 'no email')

Comments