case when if

SELECT case 1  when 1 then "one" when 2 then "two" end;

SELECT IF(1,"男","女")

posted @ 2014-05-21 18:02  UCanBeFree  阅读(91)  评论(0)  编辑  收藏  举报