[support] Searching keywords in tables also in file content

[Kamal Palei]

Hi All
I am using Drupal 6.26.

Basically I am trying to develop a site where users can come and register
their resumes .
Recruiters can serach profiles with certain keywords and select the right
profiles.

While users register profile, they might have entered skill set in a text
field, that is stored in tables.
Also users upload their resumes.

Now I am looking at how can do efficient searh both from tables , as well
as from resume file content.

Search from skill set stored in tables
--------------------------------------------------------------
Probably here, I can have integer IDs corresponding to skill sets, and
skill sets can be stored in integer format (1 skill for 1 user in 1 row in
a table),
I can probably develop some PHP code to do database query to get the
required profiles.

Search in resume file content
---------------------------------------------------------------
The resume may be a .doc or .txt or .docx or .pdf file. How can I search
the file contents, is there any module available to do that. Or I need to
use PHP code to dig into files , read the content and search.

I read about apachesolr module, just want to take experts opinion before I
proceed to use apachesolr for file search content.
Also I read about sphinx.

Kindly guide me for both the case, searching skills sets from tables , and
searching skill sets from file contents, what are best methods available
today.

Best Regards
Kamal
NECS, Bangalore
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120827/53aef336/attachment.html