Help with mysql query

[SilentK]

I have this query

PHP Code:

$reviews = $DB_site->query_first(" 
        SELECT * 
        FROM " . TABLE_PREFIX . "thread AS thread 
        WHERE thread.forumid = 58 AND thread.visible = 1
        ORDER BY dateline DESC 
         "); 


I want to change it so it only grabs threads where the first letter of the thread title equals A.

I looked through the mysql online documention of the syntax for Select and couldn't find anything on this.

My first guess would be something like

PHP Code:

WHERE thread.forumid = 58 AND thread.visible = 1 AND thread.title = a 


I am fairly certain that wouldn't work though as it would only grab ones where the title was only a correct? Is it possible to do this?

[cinq]

AND thread.title like 'a%'