A query such this :
CODE
SELECT * FROM table WHERE MATCH(title,description) AGAINST('$_POST[key]')
Almost finds everything.
I have some telephone number recorded on the site. like 032344546. If i search for 32344546 (without 0 ), search finds nothing.
If I use boolean mode, and search for 03234* it finds the number. But how can i tell it to find words that ends with the keyword ?
How can I search for 23445 (in the middle) and find 032344546 with fulltext method?? (and so the same thing with words)