choose(id,value1,value2,value3,...)
choose函数可以根据传入的id值,返回值所对应的参数值,比如传入2,那么就返回 value1,value2,value3,... 中的第二个参数值,也就是value2,下面是具体的例子。
select choose(id ,'one','two','three','four') item
from
(
select 1 as id union all
select 2 as id union all
select 3 as id union all
select 4 as id
)t
如果在choose的参数列表中在对应位置没有值,那么就会返回null,如下面:当id为5时,由于在参数列表的相应位置没有第5个参数,所以就返回了null。
select choose(id ,'one','two','three','four') item
from
(
select 2 as id union all
select 3 as id union all
select 4 as id union all
select 5 as id
)t