• ⌂ 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_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()

• < FIND_ALL_IN_SET()
• FIND_IN_SET() >