title: Code error shows cannot find column specified after where clause
body: <p>this is the code here please suggest a solution for it</p>
  
  <pre><code>UPDATE employee 
  SET cane_type = 'm', cane_value = 550 , cane_qty  = 52 , price  = 28600 
  WHERE cane_type  = 'r' ;
  </code></pre>
  
  <blockquote>
    <p>ERROR 1054 (42S22): Unknown column 'cane_type' in 'where clause'</p>
  </blockquote>