hmm, but still sticking to that you'll have to specify a new WHERE argument
for each thing you want to test on. Isn't there maybe some way to do it like
this
WHERE skill IN (regexp("powerpoint", "php"))
I know this thing won't work, becuase I don't know if you can do regular
expressions on WHERE ... IN thingies. But, such a thing would be very handy
... even more when MySQL intruduces the subselect in WHERE .. IN thingies.
Some other question, why us using REGEXP in this case better than LIKE ? is
it faster, more efficient, something with case-sensitivity maybe? I'd really
like to know
Greetz,
Wouter
----------
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: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]]
Verzonden: maandag 1 juli 2002 09:13
Aan: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Onderwerp: Re: SQL - Fulltext search
Pada Mon, 1 Jul 2002 09:01:13 +0200
"Wouter van Vliet" <[EMAIL PROTECTED]> menulis :
> I would use
>
> WHERE skill LIKE "%powerpoint%" OR skill LIKE "%PHP%"
>
where skill REGEXP "powerpoint" or skill REGEXP "php"
--
#ifdef STUPIDLY_TRUST_BROKEN_PCMD_ENA_BIT
2.4.0-test2 /usr/src/linux/drivers/ide/cmd640.c
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
---------------------------------------------------------------------
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
