如当前为大类ID=1列表页,SQL怎么写,
--------------------------------------
where charindex('1|')=1再当前类为大类ID=1下的二级类ID=10,SQL怎么写
-------------------------------------------
where charindex('1|10')=1
--------------------------------------
where charindex('1|')=1再当前类为大类ID=1下的二级类ID=10,SQL怎么写
-------------------------------------------
where charindex('1|10')=1
where charindex('1|2',category)>0
但是'1|22'也匹配出来了
where charindex('1|2',category)>0
但是'1|22'也匹配出来了
-----------------------------
这样改:
where charindex('|1|2|','|'+category+'|')>0