SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Wizard Zaggs's Avatar
    Join Date
    Feb 2005
    Posts
    1,051
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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?

    Code:
    Resolved
    Thanks

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Zaggs View Post
    Code:
    Resolved
    huh?

    does this mean you have a solution to your question?

    please, share it with us
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Wizard Zaggs's Avatar
    Join Date
    Feb 2005
    Posts
    1,051
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    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:

    Code:
    +Catia +FMEA +Design

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •