Get base url from CompleteURL using sql

Question

I want to get base url from CompleteURL using sql.

Example: completeUrl: SELECT INTO Variable in MySQL DECLARE causes syntax error?. I want get :https://stackoverflow.com/

select left(CompleteURL, charindex('/', CompleteURL, charindex('://', CompleteURL ) + 3 )  - 1 )
from urls2;