I have a search function on my website and I need to do a boolean search on a fulltext index.
For example, currently I am doing this:
match jobs.job_title against ('developer')
This works absolutely fine. However, I also have a function where the user can enter negative keywords. If they enter negative keywords, for example, "php" then results containing "php" will not be returned.
I thought of adding some extra sql like this, but is this the correct way to do things?
and (jobs.job_title not like '%php%'
and jobs.job_description not like '%php%'
and companies.company_name not like '%php%')
Thanks in advance.