Loading lesson path
Concept visual
Start at both ends
Return the index position of "q" in the string list:
SELECT FIELD("q", "s", "q", "l");The FIELD() function returns the index position of a value in a list of values.
Formula
This function performs a case - insensitive search.If the specified value is not found in the list of values, this function will return 0. If value is NULL, this function will return 0.value, val1, val2, val3, ...)
Required. The value to search for in the list val1, val2, val3, .... Required. The list of values to search
From MySQL 4.0
Return the index position of "c" in the string list:
SELECT FIELD("c", "a", "b");Return the index position of "Q" in the string list:
SELECT FIELD("Q", "s", "q", "l");Return the index position of 5 in the numeric list:
SELECT FIELD(5, 0, 1, 2, 3, 4, 5);❮ MySQL Functions