Tuesday, July 13, 2010

Remove protocol names from url in 7.4

select
            replace('https://yahoo.co.in',
                substring('https://yahoo.co.in' from '[http|htts|www.|:|//]+'),'')


Output :
 yahoo.co.in
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)