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.