You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

FIELD

Returns the first index of the str argument in the str1, str2, … list, or 0 if it doesn’t exist.

Syntax

FIELD (str, str1, str2, ...)

Arguments

  • str: any string or binary object
  • str1, str2, … : list of strings or binary objects

Return Type

Integer

Example

memsql> select field('abra', 'cadabra', 'abra', 'abracadabra');
+-------------------------------------------------+
| field('abra', 'cadabra', 'abra', 'abracadabra') |
+-------------------------------------------------+
|                                               2 |
+-------------------------------------------------+