im using a simple select query where i want to find any words in my table that begins with a certain letter, but i dont have a clue how to do it, can anyone help?
the letter is passed on from a variable on the previous page
the bit i want to search is called "band" in the table lyrics
here is my select query
//connect to database and select info
$sql="SELECT * FROM lyrics WHERE ??????? ";
$result=mysql_query($sql,$db);
plz someone help
