title: mySQL - Extract data from command output
body: <p>I am running the following <code>MySQL</code> command:</p>
  
  <pre><code>SELECT service_id AS SERVICE_ID
       , display_name AS SERVICE_NAME
       , perfdata AS PERF_DATA
    FROM services 
   WHERE display_name LIKE 'Traffic%' 
   LIMIT 10;
  </code></pre>
  
  <p><strong>The output:</strong></p>
  
  <pre><code>+------------+-------------------------------------------+----------------------------------------------------------------------------------------------------------+
  | SERVICE_ID | SERVICE_NAME                              | PERF_DATA                                                                                                |
  +------------+-------------------------------------------+----------------------------------------------------------------------------------------------------------+
  |      19563 | Traffic-Interface_Wan__0262495982         |                                                                                                          |
  |      19591 | Traffic-Interface_Wan__0262914272         | traffic_in=335,1Bits/s traffic_out=391,7Bits/s                                                           |
  |      19571 | Traffic-Interface_Wan__0262243728         | traffic_in=408,4Bits/s traffic_out=449,0Bits/s                                                           |
  |      19726 | Traffic-Interface_Wan                     | traffic_in=437,1Bits/s traffic_out=3504,9Bits/s                                                          |
  </code></pre>
  
  <p>I would like to know how to get the traffic values in order to compute the 95th percentile.</p>
  
  <p>Thanks in advance</p>