Hi.
On Thu, Dec 13, 2001 at 10:50:30AM +0000, [EMAIL PROTECTED] wrote:
> Hi
>
> I'm using the partial MySQL query:
>
> FIND_IN_SET('Specific Locations',res_places)>0; AND
> FIND_IN_SET('Wales',res_places_sl)>0;
>
> And I was just wondering why use the ">0;". Why are they needed? What does
> this tell MySQL?
http://www.mysql.com/doc/S/t/String_functions.html
FIND_IN_SET will return the position of the e.g. 'Wales' in
res_places_sl, if it is found, else 0.
FIND_IN_SET(...) > 0 tells MySQL that you want to know whether the
item was found in the set (since else the result would be 0 or NULL).
Bye,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
