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!