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.html#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]