title: 1093 error when running mysql query
body: <p>I am trying to run this query</p>
  
  <pre><code>UPDATE xxxxx_k2_categories SET params = (SELECT params FROM xxxxx_k2_categories WHERE alias = 'bread') WHERE parent = 1 MySQL
  </code></pre>
  
  <p>But am getting a 1093 error. I know this is because I am trying to update a table from it's own values but i don't know Mysql very well. Although this is really helping me learn :)</p>
  
  <p>Any help is most appreciated. </p>
  
  <p>This is my data.</p>
  
  <pre><code>Alias Parent Params Bakery 0 {Test Params 1} Bread 1 {Test Params 2} Rools 1 {Test Params 3}
  </code></pre>
  
  <p>I want to copy the value in params for item 'bread' to all rows that have a value of parent of '1'</p>