Full-text search with wildcard
I have a table with full text search enabled. But I can't get query the table using wildcard.
select * from products where contains(Description, 'Computer') returns rows with the word "Computer"
开发者_Go百科select * from products where contains(Description, 'Compute*') [replace "r" with "*"] returns nothing
What's going on?
Assuming SQL Server, add double quotes around the wildcarded expression like so
SELECT *
FROM products
WHERE contains(Description, '"Compute*"')
精彩评论