title: How to update a range of records in Mysql
body: <p>I have a table that I am trying to update a range records, I have tried multiple methods with no luck. Here is the scripts I've tried.</p>
  
  <pre><code>UPDATE va_categories SET is_showing = '1' WHERE category_id IS BETWEEN 1076 AND 1412;
  UPDATE va_categories SET is_showing = '1' WHERE category_id &gt; '1076' &lt; '1412';
  </code></pre>
  
  <p>The category_id is a Integer field.</p>
  
  <p>I would appreciate an help, banging my head here.</p>