• ⌂ Text
• Functions
  • CHAR_LENGTH()
  • CONCAT()
  • ENUM()
  • FIND_ALL_IN_SET()
  • FIND_ANY_IN_SET()
  • FIND_IN_SET()
  • INSTR()
  • LEFT()
  • LENGTH()
  • LOCATE()
  • LOWER()
  • LPAD()
  • LTRIM()
  • MATCHES()
  • ORD()
  • REVERSE()
  • RIGHT()
  • RPAD()
  • RTRIM()
  • SUBSTR()
  • SUBSTRING()
  • TRIM()
  • UPPER()

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()

• < ENUM()
• FIND_ANY_IN_SET() >