MATCH and OR gives SQL error

General Discussions - English
1

I try to combine MATCH and OR, but it fails:

WHERE MATCH(’@(title,requirements) Interim’) OR company = ‘Interim’
gives
sphinxql: syntax error, unexpected OR, expecting $end near 'OR company = ‘Interim’

Is there any way to search for

  • fields (title,requirements) for any occurance of Interim
  • and field (company) for the exact value of Interim

Any ideas?, thx!

2

OR could be used inside filters but you can not issue OR for full-text part and filter