Mysql, get data from another row in the same column : <p>I'm a beginner in mySQL and php. <a href="http://i.stack.imgur.com/Us7We.png" rel="nofollow">my database</a></p>

<p>I would like to know, how to get someones email address based on his username. So for instance if I know the username is: iamtheboss, how could I get his email?</p>
