Can I use a wildcard type phrase to call data from a table?

I want to just pull out all titles that begin with the first letter, I can display it if I have another table that just has a letter in so it would be something like

??.php?category=a

but I would prefer to use

??.php?title=a

but this will only display it if the title is 'A' and not 'a?? ??? ?????'

hope you I've made myself undderstud

SELECT * FROM mytable WHERE title LIKE 'A%'

I believe that LIKE is case sensitive. Alternatively you can use Regular Expressions.

SELECT * FROM mytable WHERE title REGEXP BINARY '^A'

The BINARY keyword tells the expression to be case sensitive.

Works a treat, thanks


Edit:

Hmm sorry did work fine until I added B now it selects a & b

Got it sorted I used

SELECT * FROM mytable WHERE `title` LIKE '$sort%'";

And just use ??.php?sort=a or ??.php?sort=b etc

Thanks for the help