Login Register






What's MySQL query for "match at least 5 of the 6 phrases" filter_list
Author
Message
What's MySQL query for "match at least 5 of the 6 phrases" #1
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?

Reply

RE: What's MySQL query for "match at least 5 of the 6 phrases" #2
I would have recommended && and || statements, but I agree. There are probably better ways. Maybe someone else knows.
[Image: 7ajmN5P.jpg]

Telegram: Oni_SL (Link)

Reply

RE: What's MySQL query for "match at least 5 of the 6 phrases" #3
StackOverflow is your friend.

Reply

RE: What's MySQL query for "match at least 5 of the 6 phrases" #4
Just figured out it's not how i want my site to shape up.

Reply