SQL - Fulltext search

Hi!

I have a table called 'candidate_skill'

id (autoincrement)
candidateID (link to candidate),
skill (tinytext)

Query: SELECT * FROM candidate_skill WHERE candidateID='2'

Result:
134 | 2 | Powerpoint
223 | 2 | PHP
313 | 2 | Lotus Notes

Is it possible to do a fulltext search. I want to search for skills.
Something like this:

+php +powerpoint

...and then get a list of all candidates that have php and powerpoint as a
skill.
Is there a way to do this?

Best regards
/Peter



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