MATCH and BOOLEAN mode

Hi Guys!

I am having a problem with a search query that I wrote. I am trying to create a boolean search but unfortunately its not working as expected. When someone searches for “Catia and FMEA and Design” it should return only results that contain all of those words. Instead the following query returns results with Catia or FMEA or Design. Any idea how to change it so that it will only match rows that contain ALL of the words?

Resolved

Thanks

huh?

does this mean you have a solution to your question?

please, share it with us

Hi r937,

I just had to add a plus symbol in front of each word I wanted to match in the sql query like this:


+Catia +FMEA +Design

:slight_smile: