THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL FIELD() Function

❮ MySQL Functions

Example

Return the index position of  "q" in the string list:

SELECT FIELD("q", "s", "q", "l");
Try it Yourself »

Definition and Usage

The FIELD() function returns the index position of a value in a list of values.

This function performs a case-insensitive search.

Note: 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.

Syntax

FIELD(value, val1, val2, val3, ...)

Parameter Values

Parameter Description
value Required. The value to search for in the list
val1, val2, val3, .... Required. The list of values to search

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Return the index position of "c" in the string list:

SELECT FIELD("c", "a", "b");
Try it Yourself »

Example

Return the index position of "D" in the string list:

SELECT FIELD("Q", "s", "q", "l");
Try it Yourself »

Example

Return the index position of 5 in the numeric list:

SELECT FIELD(5, 0, 1, 2, 3, 4, 5);
Try it Yourself »

❮ MySQL Functions