select * from pager where if(tempweek>0,instr(pweek,'xx'),instr(tempweek,'xx'))
select * from pager where if(tempweek>0,pweek, tempweek) like ?
表中数据: pweek tempWeek 135 1 135 1 135 0 2 0 2 0 4 0当tempWeek字段没有任何一条记录>0时select * from page where pweek like '%1%' 否则select * from page where tempWeek like '%1%'
select from pager where if((select max(1) from pager where tempWeek>0)=1,tempWeek,pweek) like '%1%'
from pager
where if(tempweek>0,instr(pweek,'xx'),instr(tempweek,'xx'))
pweek tempWeek
135 1
135 1
135 0
2 0
2 0
4 0当tempWeek字段没有任何一条记录>0时select * from page where pweek like '%1%'
否则select * from page where tempWeek like '%1%'
from pager
where if((select max(1) from pager where tempWeek>0)=1,tempWeek,pweek) like '%1%'