Saturday, February 25, 2012

Multiple Search Criteria using FREETEXTTABLE function

Hi,

How would one allow for possible multiple search criteria using FREETEXTTABLE. For example, my table "listings" has a full-text search catalog, and I may want to:

SELECT * FROM listings WHERE name LIKE @.name AND city LIKE @.city

I've got it working to select only by name:

SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(listings, name, 'FormsOf(INFLECTIONAL, taxes accounting') b
WHERE [KEY] = a.listing_id
ORDER BY RANK DESC, name

How would I modify this query to also search for @.city from the city column?

Thanks!

Caseyhttp://msdn2.microsoft.com/en-us/library/ms177652.aspx
hope this link helps you.

No comments:

Post a Comment