title: MySQL replace result value with another value
body: <p>I have MySQL and the query is:</p>
  
  <pre><code>select name,re_type from myTable
  </code></pre>
  
  <p>I want to replace all values of type:</p>
  
  <pre><code>1 = student
  2 = teacher 
  </code></pre>
  
  <p>So the result should be:</p>
  
  <pre><code>name    re_type
  ---------------
  Ron     Student
  Mac     Teacher
  </code></pre>
  
  <p>Not like:</p>
  
  <pre><code>name    re_type
  ---------------
  Ron     1
  Mac     2
  </code></pre>
  
  <p>Is it possible to make a query like that so I get the desired result in MySQL ?</p>