Look up freetext or fulltext depending on the db engine. MySQL: http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
SQL Server: http://msdn2.microsoft.com/en-us/library/ms176078.aspx > Hi, > > I'm trying to figure out how to create a dynamic search form using > Coldfusion 8. > > Right now if I enter multiple words in my search field the results > omit certain records. For example, if I put "toy blue" in the search > field it will return results that only have "TOY BLUE" together and > omits any records that only have "TOY" or only have "Blue" in the > column being searched. > > Is there a way to add the following abilities to my basic search code > located at the bottom of my post: > > - Search multiple words that are entered in the criteria input field. > - The words can be separated by commas, spaces, or the word "and". > - Have it so you can search multiple word phrases by using quotes. > > <!--- Search Form---> > > <form name="myForm" method="post" action="results.cfm"> > <p> > <input name="criteria" type="text" id="criteria"> > <input type="submit" name="Submit" value="Submit"> > </p> > </form> > > <!--- Results Page ---> > > <cfquery name="qSearch" datasource="myDatabase" dbtype="ODBC"> > SELECT itemID, itemName > FROM myTable > WHERE 1 = 1 > > <cfif IsDefined("form.criteria") AND Len(Trim(form.criteria))> > and (itemName LIKE '%#form.criteria#%' or itemDescription LIKE '%#form. > criteria#%') > </cfif> > > </cfquery> > > <p><b>Results:</b></p> > <cfoutput query="qSearch"> > <p>#itemid# - #itemName#</p> > </cfoutput> > > <!---------> > > Any help would be greatly appreciated. > > Thanks > > -C ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303234 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4