基于自由文本搜索（用户输入的多个单词） [英] search based on free text(multiple words entered by user)

问题描述

基于用户在搜索文本框中输入的全文，我想搜索我的tbl_products表的各个列中存在的每个单词如何实现这一点。我更喜欢使用contains而不是like.plz帮助我。欢迎使用示例而不是链接plz help

Based on the full text entered by user in "search" textbox , i want to search every words that is present in various columns of my tbl_products table how to achieve this.i prefer to use contains than like.plz help me. Examples are welcomed than links plz help

推荐答案

您可以搜索超过1列的内容

You can search in more than 1 column like that

FREETEXTTABLE(tablename, (col1,col2,col3,....), 'YourExpression')

请参阅以下链接



SQL SERVER - 2008 - 创建全文目录和完整版文本搜索 [ ^ ]



http://technet.microsoft.com/en-us/library/ms176078.aspx [ ^ ]


希望这可以帮助你...

Refer the following links

SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search[^]

http://technet.microsoft.com/en-us/library/ms176078.aspx[^]

Hope this helps you...

这篇关于基于自由文本搜索（用户输入的多个单词）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！