If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Boolean mode query question

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-07-05, 10:14
atari2010 atari2010 is offline
Registered User
 
Join Date: Feb 2005
Posts: 1
Question 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
Reply With Quote
  #2 (permalink)  
Old 02-07-05, 12:04
r937 r937 is online now
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,525
if you want AND behaviour, then you must use + on both terms

... AGAINST (' +"sales manager" +software ' IN BOOLEAN MODE)
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On