MySQL Boolean Search include field inside inner join

34 views Asked by At

how do we include in a boolean search the fields from an inner join? I have these tables:

Resume:

   id
   user_id
   job_title
   job description
   location_id  (linked to country id)

Country

id
iso_code_2
iso_code_3
name

what i want is to search for data that has Manager or Head but not have the text Philippines.

I am assuming this text will work: 'Manager Head -Philippines' but it doesnt.

Do i need to "copy" the country name into a filed in Resume?

This is currently my Query:

  select resumes.*, 
  MATCH (resumes.job_title, resumes.job_description) AGAINST ('Manager Head -Philippines' IN BOOLEAN MODE) AS relevance_1,
  MATCH (countries.name) AGAINST ('Manager Head -Philippines' IN BOOLEAN MODE) AS relevance_2
  LEFT JOIN countries ON countries.id = resumes.location_id
0

There are 0 answers