webCOMAND

FIND_ANY_IN_SET()

Returns true if any values in the first comma-separated list of values if found in the second comma-separated list of values.

Prototype

boolean FIND_ANY_IN_SET(string $find, string $set)

Parameters

  • find - A string containing a comma-separated list of values to find in set.
  • set - A string containing a comma-separated list of values to match against.

Return

Return TRUE if any value in find matches a value in set.  Otherwise, FALSE is returned.

Example

SELECT FIND_ANY_IN_SET('3,4,5',MatchSet) AS Found FROM User

Related

FIND_ALL_IN_SET(), FIND_IN_SET()