使用关键词进行从属搜索 [英] Dependant Search using key words

问题描述

你好，

Hello,

       I am Planning to write an storedProcedure for search criteria. In that sp I want to give an input parameter.... which will be like this


        @ItemSearch varchar(256)
        @ItemSearch ='2013*freedom*Kit'

If you observe the input value... The '*' in it is a separation between key word... now I want to search data having key word 2013 at first.... Then in that filtered data I ant to search with second key word 'freedom' and from that filtered records again it will filter with freedom key word... Now again if the third key word exists then it should again get filtered....In item Search the key words are not fixed.... they may vary 

Please... get me the solution if you have any way to achieve my requirement...

推荐答案

您正在寻找完整版文本搜索 [ ^ ]

[ ^ ]

搜索附近另一个单词的单词 [ ^ ]

You're looking for Full-Text Search[^]
Query with Full-Text Search[^]
Search for Words Close to Another Word with NEAR[^]

这篇关于使用关键词进行从属搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！