expression IN (value[,...])

Description: Returns 1 if expression is any of the values in the list of one or more values; 0 otherwise.

The comparison is done according to the datatype of expression. If a case-sensitive expression, the comparison is done in a case-sensitive way.

Examples:

  • 5 IN (43, 5, 12) returns 1.

  • 'a' IN ('A', 'B', 'C') returns 1.

  • BINARY 'a' IN ('A', 'B', 'C') returns 0.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.133.151.144