Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Question Unanswered: Boolean mode query question

    Why does this following query :

    SELECT `position`.`title`
    FROM `position`
    WHERE 1
    AND MATCH (`position`.`title`)
    AGAINST ('"sales manager" +software' IN BOOLEAN MODE)
    LIMIT 0 , 30

    Result in these results below, when surely it should only match any titles with the phrase "sales manager" AND software ?

    title
    ? Linux Embedded Software Engineer
    ? Senior Software Engineer X 4
    ? Software Development Manager
    ? C# Software Engineer (C#, .Net)
    ? C#/VB.NET Software Engineer - Cambridge
    ? Senior Software Engineer, Dot Net Development
    ? Embedded Software Engineer
    ? Sales Consultant/Video Editing Software
    ? IT Sales - Accounting Software
    ? IT Sales - Project Collaboration Software
    ? IT Sales - Project Collaboration Software
    ? Software Engineer - Bluetooth
    ? BDM/Sales Executive - HR & Payroll Software
    ? Bluetooth Software Engineer
    ? Embedded Software Engineer
    ? .NET Software Developer
    ? Embedded Software Engineer
    ? Bluetooth Embedded Software Engineer
    ? BDM/Senior Sales - ERP Software
    ? BDM - ERP Software
    ? New Business Sales IT Hardware And Software
    ? Senior Sales - Retail Software
    ? Senior Sales Business Intelligence Software
    ? Senior New Business - IT/Software Solutions
    ? BDM/Senior Sales - Case Management Software
    ? Sales/Account Manager Software/ERP
    ? EMEA Account Director Big Ticket Software
    ? Sales Manager/BDM BPM Software
    ? Sales Manager - Software Solutions
    ? IT Sales-ERP / Financial Software

    thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    if you want AND behaviour, then you must use + on both terms

    ... AGAINST (' +"sales manager" +software ' IN BOOLEAN MODE)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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