webCOMAND

FIND_ALL_IN_SET()

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

Prototype

boolean FIND_ALL_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 all values in find match a value in set.  Otherwise, FALSE is returned.

Example

SELECT FIND_ALL_IN_SET('3,4,5',MatchSet) AS FoundAll FROM User

Related

FIND_ANY_IN_SET(), FIND_IN_SET()