I am running the following query in my app and only 1 result is returned.
SELECT part,f2,f3,f4,f5,f7, MATCH(part,f2,f3,f4,f5,f7)
AGAINST (''nas3'' IN BOOLEAN MODE) AS relevance
FROM quotedb
WHERE MATCH(part) AGAINST (''nas3'' IN BOOLEAN MODE)
ORDER BY relevance DESC
However when i use the same search term using a like and ‘ends with query’, I get almost 10,000 results as expected as expected.
SELECT *
FROM `quotedb`
WHERE part LIKE 'nas3%'
My question is, how do I make the first query return all of the results containing ‘nas3’?