Sorry, you can't use a preceding asterisk. It is annoying. The only alternative is to use a LIKE operator.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: Philipp Wabinski [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 20, 2007 9:31 AM > To: mysql@lists.mysql.com > Subject: fulltext substringsearches? > > > Hi, > > can somebody tell me, if it`s possible to search for substrings with a > fulltext search? > > We are using a fulltextsearch in boolean mode. I tried a lot > but the search > doesn`t find any substrings. > > The mysql reference just hast got an example like this: > > "apple*" that finds everything that begins with "apple". > > Is it possible to seachr for "*ppl*" and find entries that > contain apple or > something like this without a like-search and and a full table scan? > > Thanks for any help > > Philipp > -- > View this message in context: > http://www.nabble.com/fulltext-substringsearches--tf3433702.ht > ml#a9572461 > Sent from the MySQL - General mailing list archive at Nabble.com. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]