SELECT * FROM OneTable WHERE CHARINDEX(N'一', Field)>0
AND CHARINDEX(N'元', Field)>0
AND CHARINDEX(N'天', Field)>兄销旁0
你这么写 必须得三个字全有的能查出来
SELECT * FROM OneTable
WHERE CHARINDEX(N'一羡橡', Field)>0
OR CHARINDEX(N'元', Field)>斗败0
OR CHARINDEX(N'天', Field)>0
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)