Php mysql Record Listing

[Anon]

I want to know if it is possible to list all the records but only the records that start with A in the username feild.

[danielle]

$query="select * from table_name where username like 'a%'";
$result=mysql_query($query);

while ($a=mysql_fetch_array($result)){
echo "$a[username]";
}