[SOLVED] Get any record where the first letter is X

[papaface]

Hi,

Regulars have probably seen this answered hundreds of times but how do you get records with the first letter beginning with 'a' for example?

I have this:

$letter = $_GET['l']; // = a
$query = mysql_query('SELECT alias FROM badmembers WHERE alias RLIKE "^'.$letter.'$"');

 

But it doesnt seem to work....

[papaface]

whoops it does work.

Thanks anyway lol