select case when string="1"

                   then "返回的数据1"

                   when string="2"

                   then "返回的数据2"

           else "返回的其他数据"

           end  as 新的列名

from table

where ....