Search database from list

[Guest]

Hello,
I know that this question might need to also be in the SQL forum, but I'm
not sure where I need to code this. So here it is.

I need to create a search textbox that allows users to type in multiple
words. Like if they wanted to search for "big red house". I want to return
all records that have either "big", "red" or "house" in them. How can I do
this dynamically?

Currently I just send to the database something like this:

SELECT DISTINCT *
FROM MyTable
WHERE (Description LIKE @Search)

But that only returns where description is like all search words together.
So I'm not sure if the change I'm gonna need to make is in my c# code or in
my stored procedure.

Thanks for you help
Michael

 

[David Wier]

Take a look at this 2 part tutorial on parameterized queries:
http://www.aspnet101.com/aspnet101/tutorials.aspx?id=1

It covers using the 'like' operator with SQL statements

 

[Guest]

Hello,
I know that this question might need to also be in the SQL forum, but I'm
not sure where I need to code this. So here it is.

I need to create a search textbox that allows users to type in multiple
words. Like if they wanted to search for "big red house". I want to return
all records that have either "big", "red" or "house" in them. How can I do
this dynamically?

Currently I just send to the database something like this:

SELECT DISTINCT *
FROM MyTable
WHERE (Description LIKE @Search)

But that only returns where description is like all search words together.
So I'm not sure if the change I'm gonna need to make is in my c# code or in
my stored procedure.

Michael,

all what you need is a full-text search
http://msdn2.microsoft.com/en-us/library/ms142571.aspx

Once it's enabled the query will be like the one below

select * from MyTable
where contains (Description, @Search)

Hope it helps