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