sql语句在if()、count()括号中,可写判断语句,对查询条件进行筛选
示例:if()用法
select if(pid,pid,'kai') as pid,name from user;
释意:若if()判断pid为真,则取pid值,反之,取默认值'kai'。
示例:count()用法
select count(pid = 5 or null) as pid,name from user group by name;
释义:若count()中判断条件pid = 5 或者null成立,则计数+1,反之不成立。