title: How to mark every non duplicate row in MySQL? (Merge Select and Update Statement)
body: <p>I am using this query to get all non duplicate entrys in a database:</p>
  
  <pre><code>SELECT title, COUNT(title) as cnt
  FROM my_table.books
  GROUP BY title
  HAVING cnt &gt; 1
  ORDER BY cnt;
  </code></pre>
  
  <p>I created a new column <code>no_duplicate</code> of type <code>tinyint(1)</code> in which I want to mark every row as <code>1</code>, that is unique (every output of the query above).</p>
  
  <p>Is it possible to nest an Update with the query above? Or is there an even more elegant way?</p>