----楼主可以试试下面的这个,看看效率是否有所提高
select * from oa_meeting where reg_emp_id ='10' or emc_emp_id= '10' or charindex('10',par_emp_id)>0 or rep_emp_id= '10' or charindex('10',participate)>0
select * from oa_meeting where reg_emp_id ='10' or emc_emp_id= '10' or charindex('10',par_emp_id)>0 or rep_emp_id= '10' or charindex('10',participate)>0
select * from oa_meeting where
charindex('10',reg_emp_id+emc_emp_id+par_emp_id+rep_emp_id+participate)>0
select * from oa_meeting where reg_emp_id ='10' or emc_emp_id= '10' or charindex('10',par_emp_id)>0 or rep_emp_id= '10' or charindex('10',participate)>0
-----------------
你这个语句跟楼主的结果会有偏差!!charindex(',10,',','+participate+',')>0/*啥语句效率高啊?你不把问题解决了说个有什么用,浪费表情
LZ你的分给我我都不需要...*/