MySQL supports some functions that can be used to extract the index position or the actual value from a set of values arranged as an array. ELT() and FIELD() are example of such functions. Let us understand about them in details.
Source: MySQL – ELT() and FILED() Functions to Extract Index Position From List