title: Mysql recursion?
body: <p>Consider a table like this:</p>
  
  <pre><code>   folders_table
     -----------------------
        INT id_folder
        INT id_folder_parent
        VARCHAR folder_name
  </code></pre>
  
  <p>Which stores a simple directory structure. How could I get all subdirectories of a directory with a single SELECT query?</p>