title: Update half of results of SQL query
body: <p>In MySQL I need to update half of the records of a query's results to set a column to a certain attribute.</p>
  
  <p>So something like...</p>
  
  <pre><code>UPDATE some_table SET some_column='some_value'
  WHERE some_query = 'something' LIMIT (SELECT COUNT(*)/2 FROM some_table);
  </code></pre>
  
  <p>But this will give me a syntax error.  I am wondering if this is possible and how to perform this in MySQL.</p>
  
  <p>Thanks for the help.</p>