title: Updating a price MYSQL Query
body: <p>new here and new to MYSQL</p>
  <p>I trying to create the following query and update all values from</p>
  <pre><code>[&quot;1&quot;] 
  </code></pre>
  <p>to</p>
  <pre><code> [&quot;2&quot;]
  </code></pre>
  <p>My logic:</p>
  <p>Table = mt_item
  Column = price
  Find all <code>[&quot;1&quot;]</code> values from merchant_id=55 and update to <code>[&quot;1&quot;]</code></p>
  <pre><code>SELECT 
      price
  FROM
      mt_item
  WHERE
      price = '[&quot;1&quot;]' AND 
      merchant_id = 55
  UPDATE price
  SET
  price = `[&quot;2&quot;]`
  </code></pre>
  <p>This works for me great, but now can i update the price to <code>[&quot;2&quot;]</code></p>
  <p>Hopefully you guys can help thanks.</p>