How to pass Multiple parameters in Contains Function

  • Hi,

    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.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply