MySql Match() Against() return all rows containg a word
I currently use the following query to get search results, and it works ok.
select name from table where MATCH(name) AGAINST(:searchTerm IN BOOLEAN MODE)
Thing is, if a row contained a word MariaDb, and a user search for Maria,
it'll return no results. How is it possible to do a search query that'll
return all rows containing the words Maria?
Users can also search for multiple words like Computer software
No comments:
Post a Comment