FullText Question

Databases
1

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.

2

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)