title: Delete all descendants of an entry (MySQL)
body: <p>I have a table with, let's say, the following columns:</p>
  
  <p><code>Name</code> ,  <code>Parent Name</code>,   <code>ID</code></p>
  
  <p>Let's also say that there are three entries where Parent Name is Null (meaning they are the top-most parent) - F_one, G_one, and H_one. </p>
  
  <p>If I want to delete all the descendants of one of those parents (G_one, why not?) meaning all the children of G_one, all the children of those children, and the children of those, and so on all the way until the terminal level where, that row's <code>Name</code> does not exist as a <code>Parent Name</code> for any other entry. </p>
  
  <p>Is that possible to be done easily, maybe with a single query?</p>
  
  <p>Bonus, is there a way to select all of the G_one lineage so I can manipulate it to my whim and will?</p>
  
  <p>Can assume: 
  -No Children are shared among parents</p>
  
  <p>Cannot assume:
  -A discrete or even consistent number of sub-levels. </p>