FIELD Function
FIELD Function
This Function used to get the position of a string .
Syntax
FILED(str,str1,str2,str3….)
IN this, We can find the position of str.It Return 0 if str not in given set.
Example:
SELECT FIELD(’test’,'test1′,’test’,'test2′)
Output:
2
