mysql中的case语句

1。

selectname,

case

whenbirthday<'1981'then'old'

whenbirthday>'1988'then'yong'

else'ok'ENDYORN

fromlee;

2。

selectNAME,

casename

when'sam'then'yong'

when'lee'then'handsome'

else'good'end

fromlee;

当然了casewhen语句还可以复合

3。

selectname,birthday,

case

whenbirthday>'1983'then'yong'

whenname='lee'then'handsome'

else'justsoso'end

fromlee;

更多的可以参考http://www.cnblogs.com/tillere007/archive/2010/05/25/1743210.html