Finding Parsing Domain from Email in MySQL March 21, 2008
Posted by scoopseven in MySQL.add a comment
SELECT SUBSTRING_INDEX(Email, ‘@’, -1), COUNT(SUBSTRING_INDEX(Email, ‘@’, -1)) AS numDomain
FROM TableName
GROUP BY SUBSTRING_INDEX(Email, ‘@’, -1)
ORDER BY numDomain DESC, SUBSTRING_INDEX(Email, ‘@’, -1)
Alternatives to cflocation March 12, 2008
Posted by scoopseven in ColdFusion.add a comment
Getpagecontext().getResponse().sendRedirect(‘REMOTE PATH’);
GetPageContext().forward(“LOCAL PATH”);
