One way (probably isn't the best, but it's workable depending on your site traffic) is to take and create a relationship table. I.E. Cat is related to Feline and Cat is related to Tiger, etc.
The issue is.. What do you mean by "Related" words? How broad of a scope are you taking about? Is Cat related to Dog (both animals) or is Cat related to Cities (housecats)? You need to define your scope more clearly to even see if this is feasible. On Sat, Apr 30, 2011 at 8:26 AM, Richard White <[email protected]> wrote: > > Hi, > > We use ColdFusion and MySQL (innodb) in our applications and when users > search for data we want it to also find records containing related words / > synonyms. > > What is the best way to achieve this? > > Thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344083 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
