title: cannot find for sibling folders and files from path mysql php
body: <p>I have some bunch of paths i want to get result only for sibling folders and files of a given folders. example i have paths like following</p>
  
  <pre><code>E:\xampp\htdocs\wp1\wp-content\index1.php
  E:\xampp\htdocs\wp1\wp-content\index2.php
  E:\xampp\htdocs\wp1\wp-content\dark\index1.php
  E:\xampp\htdocs\wp1\wp-content\dark\index2.php
  E:\xampp\htdocs\wp1\wp-content\dark\php\index1.php
  E:\xampp\htdocs\wp1\wp-content\dark\php\index2.php
  </code></pre>
  
  <p>if search with wp-content i want results <code>wp-content</code> root files and folders alone (wp-content root files and its sibling folder <code>dark</code> alone)</p>
  
  <pre><code>E:\xampp\htdocs\wp1\wp-content\index1.php
  E:\xampp\htdocs\wp1\wp-content\index2.php
  E:\xampp\htdocs\wp1\wp-content\dark\index1.php
  E:\xampp\htdocs\wp1\wp-content\dark\index2.php
  </code></pre>
  
  <p>if search with dark. i want results <code>dark</code> root files and folders alone like following</p>
  
  <pre><code>E:\xampp\htdocs\wp1\wp-content\dark\index1.php
  E:\xampp\htdocs\wp1\wp-content\dark\index2.php
  E:\xampp\htdocs\wp1\wp-content\dark\php\index1.php
  E:\xampp\htdocs\wp1\wp-content\dark\php\index2.php
  
  
  SELECT * FROM table WHERE  file REGEXP 'wp-content[*\\{2,3}]'
  </code></pre>
  
  <p>i tried like above this does not works. 
  i want matches like after <code>wp-content</code>(searching folder) only <code>1 or 2 not more than that</code> slashes should be there.</p>