MySQL MATCH query for part words
Posted on 2010-11-17
I am trying to find all the records which include the word intervention or an extension thereon.
MATCH(other_information) AGAINST('Intervention' WITH QUERY EXPANSION)
I have a Fulltext index set and all records with 'Intervention' appear, but records with 'Interventions' do not appear.
What do I need to add for this?
All help is appreciated