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
[email protected]
SO43 7DS 07801 715200
[email protected]
----------------------------------------------------------