title: mysql query to update all values +1 where value is less than 100
body: <p>I have a table like this: </p>
  
  <pre><code>create table `test` 
  (
      `id` bigint(20) NOT NULL AUTO_INCREMENT, 
      `value` smallint (3) NOT NULL,
  </code></pre>
  
  <p>I am trying to make a <code>mysql</code> query that increment every <code>row</code> in the <code>test</code> table where <code>value</code> is less than 100.  </p>