sql query using FULLTEXT index

[stubarny]

Hi eveyone,

 

I'm using the following code to find search results for a jobs board.

 

select * from ( SELECT ad_title, ad_location, ad_number, ad_timestamp, MATCH (ad_title) AGAINST ('+engineer ' IN BOOLEAN MODE) FROM ads_live WHERE ( ( ad_type = 'permanent' ) OR ( ad_type = 'contract' ) OR ( ad_type = 'temporary' ) OR ( ad_type = 'part_time' ) OR ( ad_type = 'internship' ) ) AND ( ad_iso_country = 'us' ) LIMIT 50,100 ) as a order by a.a.ad_timestamp DESC

 

The code finds adverts that match the selected criteria, with the exception of the fulltext index search on the ad_title column for the keyword 'engineer' - it is returning all records whether or not they include the keyword.

 

Do you have any idea why this may be happening and how to ensure only records that include the keyword 'engineer' are returned?

 

Thanks! 

 

Stu

[fenway]

Fulltext indexing is funny, and can often return funny result sets -- check the docs.