Please help me with this fulltext query!

Sorry for posting the question once again, but I really need help.
I hope someone has an answer...

Best regards
/Peter


----- Original Message -----
From: "Peter Engström" <peten714@xxxxxxxxxxxxxx>
To: <mysql@xxxxxxxxxxxxxxx>
Sent: Wednesday, June 26, 2002 3:49 PM
Subject: Fulltext query


> Dear listmembers,
>
> I have two tables
>
> candidate_index
> candidate_skill
>
> candidate_index hold information about the candidate like id
> (autoincrement), firstName, lastName
> and emailAddress.
>
> candidate_skill has three columns
> - id (autoincrement)
> - candidateID
> - skill
>
> client_index has a fulltext index (firstname, lastname)
> client_skill has a fulltext index (skill)
>
> A candidate can have several skills and they are all stored in
> table candidate_skill.
>
> I want to make a fulltext search on the skills and the candidate
> information.
> For example enter '+perl +html +peter'.
>
> I've tried with sql query, but it doesn't work.
>
> SELECT
>             DISTINCT candidate_index.id,
>             candidate_index.firstName,
>             candidate_index.lastName
> FROM
>             candidate_index,candidate_skill
> WHERE MATCH
>            (candidate_index.firstName,
>             candidate_index.lastName,
>             candidate_index.skill)
> AGAINST
>             ('+perl +html +peter')
>             AND candidate_index.id=candidate_skill.id
> LIMIT 5
>
> Does anyone have a solution for my problem?
>
> Thanks
> /Peter
>
> Ps. Is it better to create an extra column in candidate_index
> called 'everything' (longtext) and store an copy of the candidate's
> skills and info in the column and then just make an fulltext on the
> column. I have about 80 000 candidates and each candidate has
> about about 10 skills. Ds.
>
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread113024@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
<mysql-unsubscribe-peten714=student.liu.se@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



---------------------------------------------------------------------
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 <mysql-thread113338@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php