关于模糊搜索的问题

[haojialu]

我想实现以下效果,譬如在搜索筐中输入"螺纹钢"
程序将对关键词"螺纹钢"进行任意拆分查询,即对数据库中"标题"和"内容"两个字段进行"螺纹"或"螺纹钢"或"纹钢"进行查询.baidu的搜索好像就是这样的.
请大侠帮忙,
螺纹钢只是一个实例,可能会有更长的词,譬如输入"发表问题前",即对数据库进行"发表问题前","发表","问题","表问","题前","发表问","表问题","问题前","","发表问题","表问题前"进行搜索.
当然其中只有"发表问题前","发表","问题",才是有价值的搜索.
我是用asp.net vb的

[mymyal123]

like '% %'

[mymyal123]

不好意思,发错了,没看清

[haojialu]

顺便问大家一个组合搜索的问题:
dim tSQL as string = "select * from xxx where a like '%"+stra+"%' and b like '%"+strb+"%' or c like '%"+strc+"%' order by shijian DESC"
上面的代码层次关系好像是a and ( b or c)
而我想要的效果是
(a and b) or c
请问大侠应该怎么写呀???

[haojialu]

写错了!!!!!!!!!!
顺便问大家一个组合搜索的问题:
dim tSQL as string = "select * from xxx where a like '%"+stra+"%' and b like '%"+strb+"%' or c like '%"+strc+"%' order by shijian DESC"
上面的代码层次关系好像是: (a and b) or c
而我想要的效果是a and ( b or c)

请问大侠应该怎么写呀???