select if(sva=1,"男","女") as ssva from taname where id = '111';. 作为表达式的if也可以用CASE when来实现: select CASE sva WHEN 1 THEN '男' ELSE ...
確定! 回上一頁