sql query using FULLTEXT index
Posted: Fri Mar 30, 2007 9:38 am
pickle | Please use
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
pickle | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too. Also - properly indenting code/sql makes it much easier to read[/color]
Hi eveyone,
I'm using the following code to find search results for a jobs board.
[syntax="sql"]
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 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
pickle | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]