Jump to content

text~=A|B|C search order results


joe_g
 Share

Recommended Posts

When doing an OR search like

text~=A|B|C

This gives results that contains just "A", as well as "A B C". The results gets ordered in whatever manner they are ordered in the CMS, unless specifically sorted on a field. What I want, however, is to show the results that contain "A B C" first, then the results that contain "A C", "B C", "A B" afterwards, and then finally the results that contain only "A", or "B" or "C"

possible? Thanks!

Bonus points for being able to de-emphasize filler words like "my", "if", etc. But I realize this might be a bit too advanced?

 

Link to comment
Share on other sites

  • 2 weeks later...
On 1/9/2020 at 3:20 PM, joe_g said:

Bonus points for being able to de-emphasize filler words like "my", "if", etc. But I realize this might be a bit too advanced?

You can try to fine-tune the DB https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html

And for advanced stuff, you can play around with fulltext searches (raw mySQL queries).

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...