i have created the full text index on the table candidates.
I am Storing candidates resume in c_resume text filed.
Presently I am passing Only Technology
select * from candidates WHERE contains(c_resume_text,'C') -It showing results.
I need to pass here Technology and City Also like in Contains Funtion how can i write the query C,Houston,Amsterdam
How to write the Query to pass both multiple cities and Technology in above Query.
Please Help Me.