Hi I have a table "Item" with 5 varchar columns
id, factory, type, category, section
i currently am using LIKE queries to generate keyword search results
SELECT id from Item WHERE id LIKE ('%foo bar%') OR type LIKE ('%foo
bar%') ... etc.
However it was suggested to me to use the MATCH() function so I could
get relevance scoring.
So I did
ALTER table Item ADD FULLTEXT (id, factory, type, category, section)
however when I do a search with the MATCH query 'fo' doesn't match,
although 'foo' will.
Is there a way to combine the MATCH query with the LIKE ...