Full-text search with wildcard

Question

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"

select * from products where contains(Description, 'Compute*') [replace "r" with "*"] returns nothing

What's going on?

possible duplicate of [How do you get leading wildcard full-text searches to work in SQL Server?](http://stackoverflow.com/questions/3400/how-do-you-get-leading-wildcard-full-text-searches-to-work-in-sql-server) — JohnFx, Jul 30 '10 at 21:54

score 1 · Answer 1 · answered Jul 30 '10 at 21:57

1

Assuming SQL Server, add double quotes around the wildcarded expression like so

SELECT * 
FROM products 
WHERE contains(Description, '"Compute*"')

answered Jul 30 '10 at 21:57

JohnFx

1 Answers1