title: How to read a value from a xml column in mysql?
body: <p>Given: </p>
  
  <pre><code>mySql table with a column containing xml
  </code></pre>
  
  <p>Find: </p>
  
  <pre><code>sql query extracting a value
  </code></pre>
  
  <p>preferred Usage:</p>
  
  <pre><code>select ExtractValue(xmlColumn, 'xPath/to/value') from table;
  </code></pre>
  
  <p>Knowledge:</p>
  
  <p>here first a xml element has to be set </p>
  
  <pre><code>set @xml
  select ExtractValue(@xml, 'xPath/to/value);
  </code></pre>
  
  <p>how to set my xml column as @xml in one query ?</p>