select student.* from student where student.course like (select teacher.course from teacher where teacher.name='A');
學生的課程欄位是:課名–課名–課名–;
老師的課程欄位是:課名;
上面的代碼輸出是精確查詢，不是我想要的。請問下模糊查詢應該怎么寫。
uj5u.com熱心網友回復：
拜托大神們幫幫忙，萬分感謝
uj5u.com熱心網友回復：
select student.* from student where student.course like (select N'%'+teacher.course+N'%' from teacher where teacher.name='A');uj5u.com熱心網友回復：
反了啊，這還是不對。
。想輸出之后再模糊查詢
uj5u.com熱心網友回復：
select *from student b
where exists (select course from teacher a where a.name='wsy' and CHARINDEX(ltrim(rtrim(a.course)),b.course)>0)
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/131057.html
標籤：疑難問題
上一篇：html網業能變成網站嗎，如何變