FIELD() FUNCTION in MySQL
FIELD() FUNCTION The MySQL FIELD function is used to get the position of a value in a list of values. The various versions of MySQL support the FIELD function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23. Syntax: FIELD( value, val_1, val_2, … val_n ) … Read more