Hi everyone,
I'm getting an error message with the following sql query which I think is being caused by the way I've structured the query rather than problems with variables:
select * from ( SELECT ad_title, ad_location, ad_number, ad_timestamp MATCH (ad_title, ad_body) AGAINST ('research' IN BOOLEAN MODE) AS Score 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 error message is:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MATCH (ad_title, ad_body) AGAINST ('research' IN BOOLEAN MODE) AS Score FROM ads' at line 1
I'm not used to queries as complex as this that use fulltext indexes so I may have made a simple mistake?
Thanks for your help!
Stu
