I am having search functionality in my website, it allows user to type multiple keywords separated by comma(ex: php,3years,bangalore).
I am having 4 to 5 fields(skills,location,experience,title,qualification,etc.,) which user will search for. when user search for with 3 or 4 keywords(or more, similar to naukri or monster search).i want to know how that query will be.
I don't want to run that query in foreach row for every string. Is there anyway i can do it?