Results 1 to 1 of 1
Nov 23, 2005, 09:20 #1
search uploaded text and MySQL table in same query
I am building a resume posting app. Users can check qualifications that set enum flags in the database and upload plain text resume's also.
I need a way to search for matches to the enum fields in the database (searchers will select what to match with radio fields on the web form) and also look for text within the uploaded resume text.
What is the best way to approach this?
Can it be done with one query? Or do I need to produce one result set and then the second and compare these result arrays for matches?
Any ideas to focus my thoughts on this will be welcomed.