title: Sorting of Alphanumeric data by MySql
body: <p>I want to sort alphanumeric data by mysql. My data is some typicall type like:</p>
  
  <pre><code>XYZ-1.0-7.0-1
  XYZ-1.0-27.0-5.7
  XYZ-1.0-20.0-4.6
  XYZ-1.0-10.0-2.4
  ----------------- many more data in this format ------------
  </code></pre>
  
  <p>I googled and found many links, but none are working.</p>
  
  <p>I want this data as output:</p>
  
  <pre><code>XYZ-1.0-7.0-1
  XYZ-1.0-10.0-2.4
  XYZ-1.0-20.0-4.6
  XYZ-1.0-27.0-5.7
  </code></pre>