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:
http://dev.mysql.com/doc/refman/4.1/en/fulltext-boolean.html
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