SQL Server Full text search Contains function

pvcm50d1 于 2023-03-17 发布在 SQL Server

关注(0)|答案(2)|浏览(125)

İ have a problem with contains function, when i search with like '%ZAM%' operator, it finds all word that contains ZAM like ZAMANLAMA AZAMI ZAM and etc.. but when I use fts index contains function, it just find ZAM ZAMANLAMA but it doesnt find AZAMI or 123ZAM789. I have also tried CONTAINS (YourColumn, ' "ZAM" ' ) but it doesn't work. Please help me , fts is very fast but it could not find all contains like '%%' operator what should I do ?

sql-server

来源：https://stackoverflow.com/questions/45912203/sql-server-full-text-search-contains-function

2条答案

按热度按时间

zzwlnbp81#

SQL Server Fulltext Search (Version 2022) does not support postfix search, like '"*zam"' .

https://dba.stackexchange.com/a/230067

https://learn.microsoft.com/en-us/sql/relational-databases/search/query-with-full-text-search

赞(0）回复(0）举报 2023-03-17

qgelzfjb2#

You can use "*" before in contain syntax same as like operator . but you need to use double quote before and after the search string. Try this query once.

SELECT *
FROM YourTable
WHERE CONTAINS(YourColumn,'"*ZAM*"');

(OR)

select * from YourTable where YourColumn like '%ZAM%'

赞(0）回复(0）举报 2023-03-17

我来回答

SQL Server Full text search Contains function

2条答案

相关问题

热门标签

最新问答