请问有什么最佳方法可以在mysql查询中使用IF语句,以显示如果“email”字段为空,则应显示为“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
----------------------------------------------------------