MySQL FULLTEXT searches support wildcard suffixes such as:

mysql> SELECT * FROM articles WHERE MATCH (title,body)
-> AGAINST ('apple*' IN BOOLEAN MODE);

which returns all title/body lines that contain the prefix 'apple',
such as

appleby
appleseed

but not

bigapple
redapple

This is described online at:

[url]http://dev.mysql.com/doc/refman/4.1/en/fulltext-boolean.html[/url]

Question: can FULLTEXT be configured to support wildcard
prefixes _and_ suffixes simultaneously? IE, something like:

mysql> SELECT * FROM articles WHERE MATCH (title,body)
-> AGAINST ('*apple*' IN BOOLEAN MODE);

so that we would get back all of the above results:

appleby
appleseed
bigapple
redapple

Thanks,
creadcdd