Hi! I have 2 tables
Table 'candidate_index' holds information like firstName,lastName,phoneNumber etc. Example id | firstName | lastName | phoneNumber 1 | Peter | Engström | 3236363 2 | John | Smith | 3773737 ... Table 'candidate_skills' holds the skills a candidate have Example id | candidateID | skill | 1 | 1 | Office 2000 | 2 | 1 | PHP | 3 | 2 | C++ | 4 | 1 | Java | 4 | 2 | Java | ... I want to make a fulltext search in both the candidate information + the skills. Is this possible? How do I do it? If I for example search for '+peter +java' I want candidate 1 to come up as a hit. Do I need to group the skills with the candidate info? How do I do this? Is it a good idea to create an extra table called 'candidate_fulltext' with one big 'text' column and insert all the information and just make the fulltext search in this table? Table 'candidate_fulltext' holds the details about the candidates + the skills Example candidateID | bigtext_to_use_for_searching id | Peter Engström 3236363 Office 2000 PHP Java Or is there another solution? Best regards /Peter Ps I have 50 000 candidates and each candidate have about 10 skills Ds. sql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
