34,593
社区成员
发帖
与我相关
我的任务
分享
select * from T_COURSE as a where (C_TEACHER_IDS like '%119,%' or C_TEACHER_IDS like '%,119,%' or C_TEACHER_IDS like '%,119%' )
select * from T_COURSE where ','+C_TEACHER_IDS+',' like '%,119,%'
--或者:
select * from T_COURSE where charindex(',119,',','+C_TEACHER_IDS+',')>0
select *
from T_COURSE as a
where ','+C_TEACHER_IDS+',' like '%,119,%'
--对栏位 C_TEACHER_IDS 前后加逗号处理
--用這個即可
where charindex(',119,' , ','+C_TEACHER_IDS+',') >0