select c provincename, case when ${yppz}= 'Y0115' then jg_q when ${yppz}= 'Y0303' then jg_c else '0' end scj from yc_jcljgjschjc_ORC where calday = '${tjdate}'
select c provincename, case when 'Y0115' in (REPLACE(${ypqz}, ",", "','") ) then jg_q when 'Y0303' in (REPLACE(${ypqz}, ",", "','")) then jg_c else '0' end scj from yc_jcljgjschjc_ORC where calday = '${tjdate}'你这么写试一下捏