listing values in a column in MySql that begin with a certain letter?

[SiaMensiS]

I'm trying to figure out how to do it so that when a user clicks on a certain letter  of the alphabet that has been listed, how does I get it to list everything in that column that begins with that letter i.e they click on the A, and it lists everything in that column that the letter is A

 

So apple will be listed, but no Banana, also non case-sensitive.

 

Thanks

[killerb]

<?php
$query = "SELECT * FROM tablename WHERE colname LIKE '{$letter}%'";