Results 1 to 3 of 3
Thread: MySQL MATCH AGAINST and NOT LIKE
Apr 4, 2012, 06:04 #1
MySQL MATCH AGAINST and NOT LIKE
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')
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%')
Apr 4, 2012, 07:43 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 53 Post(s)
- 2 Thread(s)
Apr 4, 2012, 07:45 #3