The following query:
SELECT NVP('entree=orange chicken&entree2=honey salmon', 'entree');
returns 'orange chicken'.
In this example, name_delimiters is & (default value), value_delimiters is = (default value), and occurrence is 1 (default value).
The following query:
SELECT NVP('entree=orange chicken&entree2=honey salmon', 'entree');
returns 'orange chicken'.
In this example, name_delimiters is & (default value), value_delimiters is = (default value), and occurrence is 1 (default value).