hi, im looking to put wildcards in my full-text search... can it be done???
my query is
$query = "SELECT *,
MATCH(synopsis, title_english, title_original) AGAINST('$searchValue') AS score
FROM film_information WHERE MATCH(synopsis, title_english, title_original) AGAINST('$searchValue')
ORDER BY score DESC";
which works fine if your $searchValue is in there, but for example:
a search for 'plants' works fine, but a search for plant does not, so i would like to do a search for
'*plant*', which would pick up, "plants", or "eggplant".... etc etc
i hope you understand what im trying to do.