UC知道sql嵌套语句，大家帮忙看看，我想把=换成like不成功，
来源：百度知道 编辑：UC知道 时间：2024/06/20 15:18:27
select ID,Tid,Title,Author,Adddate,Hits,Intro,Picurl,FullTitle,KS_junjia,KS_quyu,KS_nianfen,KS_leixing,(select count(id) from KS_U_esf where KS_xiaoqu=KS_U_xq.Title) as commenttotal from KS_U_xq where deltf=0 and verific=1 order by id desc
select ID,Tid,Title,Author,Adddate,Hits,Intro,Picurl,FullTitle,KS_junjia,KS_quyu,KS_nianfen,KS_leixing,(select count(id) from KS_U_esf where KS_xiaoqu like '%KS_U_xq.Title%' ) as commenttotal from KS_U_xq where deltf=0 and verific=1 order by id desc
上一句用=就可以，用like就不行，
帮忙看看问题在哪里
select ID,Tid,Title,Author,Adddate,Hits,Intro,Picurl,FullTitle,KS_junjia,KS_quyu,KS_nianfen,KS_leixing,(select count(id) from KS_U_esf where KS_xiaoqu like '%KS_U_xq.Title%' ) as commenttotal from KS_U_xq where deltf=0 and verific=1 order by id desc
上一句用=就可以，用like就不行，
帮忙看看问题在哪里
like '%'+KS_U_xq.Title+'%'
KS_U_xq.Title 表名+列名是指定具体的列，表示条件必须满足KS_xiaoqu=KS_U_xq.Title。如果把它放在 ''里面就成了字符串，就不再一个列了，意思是KS_xiaoqu列中包含有'KS_U_xq.Title'字符串的