title: Mysql : assign integer value to the String values and get the average
body: <p>I am using mysql database. i have a table called feedback which has a field <strong>howIsTraining</strong>
  which may have one value out five values "Excellent, Very Good, Good, Poor and Pathetic"</p>
  
  <p>i want to write the query which will give average of this value from all the data in following format</p>
  
  <p>I want give integer value to each of the values</p>
  
  <p>Excellent = 5 
  Very Good = 4
  Good      = 3 
  Poor      = 2
  Pathetic  = 1</p>
  
  <p>if say i have five records in table Excellent,Very Good,Excellent,Good, Poor 
  that means <strong>((5+4+5+3+2)/5) = 3.8</strong></p>
  
  <p><strong>finally it will give result as 3.8</strong> </p>