Getting substring through regexp in mysql query

Question

I have tried all the things like regexp ,substring for getting domain name from uri 'http://start.readingresults.com/RapidResults/vocab_web_alt/reviewResponseAjax.do' but failed to get accurate result.It should show me www.start.readingresults.com.Somatimes uri includes ip address which make me this thing more complex.Such as 192.168.1.10 etc. Which is more proper way to find domain regexp or substring?

What's your programming language? Try to look for '//' then look for first '/' then everything between indexOf("//") and indexof('/') is the domain — Alepac
– Alepac, Commented Apr 12, 2013 at 9:46

Alepac · Accepted Answer · 2013-04-12 09:59:27Z

2

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('http://start.readingresults.com/RapidResults/vocab_web_alt/reviewResponseAjax.do', '//', -1),'/',1);

if your URL having ip address means you have to handle in separate way using SUBSTRING_INDEX

Here the sqlfiddle.

Cheers...

edited Apr 12, 2013 at 9:59

Alepac

1,84313 silver badges24 bronze badges

answered Apr 12, 2013 at 9:47

Sundar G

1,0661 gold badge11 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting substring through regexp in mysql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related