title: need to parse up to 3rd / in a string by using regexp in sql
body: <p>when i am trying extract through <code>regexp</code> from the below source by using <code>\|(.*?),1,2</code> this, i am getting up to end but i need to 3rd / only. when i use  <code>\|(.*/){1,3},1,2</code> it is giving <code>http://localhost:6148372/content/bdsajf</code> and i am stuck up at ending search position. please help me on this.</p>
  
  <pre><code>U=https://www.abcdf.com/aecb/app/login|http://llcwokhfkdvc.webs.com/sajc-services
  U=http://localhost:7438/en.html|http://localhost:6148372/content/bdsajf/en/kjf-LKJf/FJKSF-cbxjs.html
  </code></pre>
  
  <p>O/P should be # <code>http://llcwokhfkdvc.webs.com</code> and <code>http://localhost:6148372</code></p>
  
  <p>Thanks</p>