SELECT CASE WHEN field= ‘‘ THEN ‘1‘ WHEN fieldIS NULL THEN ‘1‘ ELSE field END FROM tablename
【Mysql】 case ... when ... 用法
原文：http://www.cnblogs.com/richerdyoung/p/7833260.html
