在SQL Server中搜索FuLLText [英] FuLLText Search in SQL server

问题描述

我的表格列中有大量的数据加载和执行FullTextSearch。假设在我的专栏中我有stjohns，saintanns，st.Peterburg，如果我通过st。然后它应该返回所有这三个值..请帮我解决这个问题，即使我尝试用噪音来消除'。'，但它不起作用。



谢谢提前

Lohieth

I Have a loads and loads of data in my table column on which FullTextSearch is to be performed.For suppose in my column i have stjohns,saintanns,st.Peterburg and if i pass "st." then it should return all the three values..Please help me regarding this, Even i tried noise words to eliminate '.', but it is not working.

Thanks in advance
Lohieth

推荐答案

你需要这样的东西：

You would need something like this:

Select * From [table] where [column] like '%st%' and [column] like '%saint%'

请彻底，

Please go thorough,

-- stjohns, saintanns, st.Peterburg
-- and if u pass "st." then 1 reocrds will display -> st.Peterburg
-- and if u pass "st" then 2 reocrds will display -> stjohns, st.Peterburg
-- and if u pass "s" then 3 reocrds will display -> stjohns, saintanns, st.Peterburg

Declare @val varchar(100) = 's'

SELECT *
FROM YourTableName
WHERE YourColumnName Like '%+ @Val +%'

祝你有美好的一天!!!

Have a great day !!!

这篇关于在SQL Server中搜索FuLLText的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！