Expanding Search Functionality ??

[jimmy_hunt]

Hello,

I have a table that has a column for a title and a column for description. I want to create a search functionality that will allow a user to enter in a string and click submit to search through both the title and description columns.

I have a generic sql query:

...where title LIKE '%#txtSearch#%' or description LIKE '%#txtSearch#%'

to get results right now. I'd like to extend my searching to allow a user to enter multiple words that don't have to be in perfect sequence to get a result. Does any one have any ideas on how to do this?

Thanks!
James

[Dan_Bracuk]

you would have to put all the words in a list first, with no spaces between the list elements. Then, in your query, you need something like:

and
(
<cfloop list=yourlist index="word">
title like '%#word#%' or description '%#word#%'
<cfif listfind(yourlist, word) lt listlen(yourlist)>
or
</cfloop>
)

[drforbin1970]

How many records are we talking about? SQL Server has Full Text Indexing that does exactly what you are looking for and is the best way to go if you will have large amounts of data.