+- Sinisterly (https://sinister.li)
+-- Forum: Coding (https://sinister.li/Forum-Coding)
+--- Forum: Coding (https://sinister.li/Forum-Coding--71)
+--- Thread: What's MySQL query for "match at least 5 of the 6 phrases" (/Thread-What-s-MySQL-query-for-match-at-least-5-of-the-6-phrases)
What's MySQL query for "match at least 5 of the 6 phrases" - Vyktochr - 08-05-2014
The user searches for #ham #cat #meme
It can't find all three so it needs to check to see if at least two can find a match.
I can create a combination of && and || statements, but I don't think that is the most efficient way.
is there a way to check to see if 2 tags are matched?
RE: What's MySQL query for "match at least 5 of the 6 phrases" - Oni - 08-05-2014
I would have recommended && and || statements, but I agree. There are probably better ways. Maybe someone else knows.
RE: What's MySQL query for "match at least 5 of the 6 phrases" - Lain - 08-05-2014
StackOverflow is your friend.
RE: What's MySQL query for "match at least 5 of the 6 phrases" - Vyktochr - 08-05-2014
Just figured out it's not how i want my site to shape up.