I would use WHERE skill LIKE "%powerpoint%" OR skill LIKE "%PHP%"
but that is because I don't know the better way, which must be there, I feel it .. anybody? ---------- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. -----Oorspronkelijk bericht----- Van: Peter Engström [mailto:[EMAIL PROTECTED]] Verzonden: zondag 30 juni 2002 20:32 Aan: [EMAIL PROTECTED] Onderwerp: 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
