What will MySQL return if the search string is not in the list of strings provided as a parameter in the FIELD() function?

Assume that if the search string is not in the list of strings provided as parameters in the FIELD() function, then MySQL will return 0 as output.

Example

mysql> Select FIELD('Ram','New','Delhi');
+----------------------------+
| FIELD('Ram','New','Delhi') |
+----------------------------+
|                         0  |
+----------------------------+
1 row in set (0.00 sec)

The above is the detailed content of What will MySQL return if the search string is not in the list of strings provided as a parameter in the FIELD() function?. For more information, please follow other related articles on the PHP Chinese website!