I have a table with fulltext indexing on three columns. In one of these columns has the value: Testing
When I use the query below I get no results:
SELECT id, MATCH(col1, col2, col3) AGAINST('Test') AS score FROM mytable WHERE MATCH(col1, col2, col3) AGAINST('Test') ORDER BY score DESC
But nothing gets returned. But when I use the search term: Testing instead of just test, the row I am looking for is returned.
I know i can use LIKE to do this, but is there a way within the fulltext searching to return more than just exact matches?
Any ideas would be much appreciated, thanks in advance.
i've found that you cand use this for prefixes,
AGAINST('searchstring*' IN BOOLEAN MODE)
but why doesn't this work
AGAINST('searchstring' IN BOOLEAN MODE)