Tag: Email
5 Simple rules for managing your Email Inbox
June 12th, 2009, 1 Comment
A few years ago, one of the most time consuming but un-productive parts of my day was checking and managing email Inbox. Back then, I used to have one big list of all my emails (the Inbox), with things I did not need to see ever again continuously taking up screen space and brain time.
Then [...]
Where are your users from? – (By SQL Email Domain)
April 19th, 2009, 1 Comment
Ever wondered who your users use as their email provider? Who are the biggest email providers of the users on your website? Luckily SQL has the answer in 1 easy step using the SUBSTRING_INDEX string function.
mysql> SELECT COUNT(*) AS Total, SUBSTRING_INDEX(email, ‘@’, -1) AS Domain FROM users GROUP BY SUBSTRING_INDEX(email, ‘@’, -1) ORDER BY COUNT(*) [...]