title: Delete with select in mysql
body: <p>I have 3 columns(id,parent,value) with some data and this query:</p>
  
  <pre><code>SELECT * FROM test WHERE id = (
      SELECT parent FROM test WHERE id=2 AND value='value' LIMIT 1
  );
  </code></pre>
  
  <p>The query above works great.</p>
  
  <p>Now how can I delete instead of select that id in one query?</p>