EXTRACTVALUE « XML « SQL / MySQL






  1. SQL / MySQL
  2. XML
  3. EXTRACTVALUE
1.Using EXTRACTVALUE function
2.Using EXTRACTVALUE function with xml data
3.Replace result from EXTRACTVALUE
4.EXTRACTVALUE function and * wild card
5.EXTRACTVALUE fuction and //
6.EXTRACTVALUE function and //tagName
7.EXTRACTVALUE(MATCH_INFO, '/match//*')
8.EXTRACTVALUE(MATCH_INFO,'//town|//won')
9.Concatenate value from EXTRACTVALUE function




10.EXTRACTVALUE(MATCH_INFO,'/match/@number')
11.EXTRACTVALUE function and calculation
12.Using EXTRACTVALUE function in where clause
13.Match two values from one EXTRACTVALUE function