Not being an expert on FULLTEXT functions yet, I suppose you could hard code some type of search function into your application code, then create all the relevant search options for the FULLTEXT query in your app logic, then post the FULLTEXT query off to mysql.
Or store the different search options in mysql tables. Then retrieve those options to build the multiple-name FULLTEXT search. Then send the query back to your database? Regards Keith On Thu, 13 Apr 2006, Taco Fleur wrote: > To: mysql@lists.mysql.com > From: Taco Fleur <[EMAIL PROTECTED]> > Subject: customized variations on words with fulltext > > Hi all, > > sorry for all the questions lately, just getting my feet wet in MySQL. > > Is there any way to create my own variations on words so that MySQL will > include those in the fulltext search? > > What I am after is for example if someone enters VB, I'd like the search to > also look for; > - Visual Basic > - VisualBasic > > Is this possible, if so how? > > Thanks in advance for any help. > > Kind regards, > > > Taco Fleur > > Free Call 1800 032 982 or Mobile 0421 851 786 > Pacific Fox <http://www.pacificfox.com.au/> http://www.pacificfox.com.au an > industry leader with commercial IT experience since 1994 . > > * > > Web Design and Development > * > > SMS Solutions, including developer API > * > > Domain Registration, .COM for as low as fifteen dollars a year, > .COM.AU for fifty dollars two years! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
