Product Solutions Support
Try MemSQL

FIELD

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

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

Arguments

Return Type

Integer

Example

memsql> select field('abra', 'cadabra', 'abra', 'abracadabra');
+-------------------------------------------------+
| field('abra', 'cadabra', 'abra', 'abracadabra') |
+-------------------------------------------------+
|                                               2 |
+-------------------------------------------------+
Was this article useful?