Only display records that start with 'a'

[Anon]

How do I display only the records in which the leading field (movTitle) starts with a particular letter, such as "a" or "b"?

[Anon]

mysql_query("SELECT movie_id FROM movies WHERE movTitle LIKE 'a%'");

[Anon]

thankyou very much, that solved all my problems.

[Anon]

Thanks dude .. i was thinking about this one too.

such a simple solution too, just a bolean (spelling ?) search with out the % on the other side of "a"

thanks again 🙂