MySQL multiple querys with most matching item on top

Asked Oct 10 '16 at 19:55

Active Oct 10 '16 at 19:56

Viewed 44 times

I have a MySQL database containing items with a name.
I also have an array of keywords.
My plan is to send multiple queries to the database using something like

foreach($keywords as $keyword){
 $result = $mysqli->query("SELECT * FROM items WHERE name LIKE %$keyword%");   
}

After that I want to sort the results after the highest amout of matches, so that the item found using the most queries is on top while others are down below...

My questions: Is this recommendable? Is this a performance killer? If my idea is stupid, is there a better way to do this?

asked Oct 10 '16 at 19:55

RoiEX

1,186
1
10
37

@KoenHollander not sure, soundex against the list. Hmm – Drew Oct 10 '16 at 20:00
Using `name LIKE '%$keyword%' OR name LIKE '%$keyword2%'.......` would be better than multiple queries – RiggsFolly Oct 10 '16 at 20:00
1

How about this answer of mine [Here](http://stackoverflow.com/a/30677347/1816093) ... last block, scroll over, column called `relevance` ? `FULLTEXT` search btw – Drew Oct 10 '16 at 20:02
^^^^^^ That looks better still – RiggsFolly Oct 10 '16 at 20:02
@Drew is there a way to exclude search results containing blacklisted words? – RoiEX Oct 10 '16 at 20:59
Yes, [here](http://stackoverflow.com/a/37604988) – Drew Oct 10 '16 at 21:18
The above was for Stopwords. Probably not what you meant. Try thiis here http://stackoverflow.com/a/3914883 – Drew Oct 10 '16 at 21:30

MySQL multiple querys with most matching item on top

0 Answers0