PDA

View Full Version : Help with mysql query


SilentK
05-26-2005, 11:21 PM
I have this query

$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

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
05-27-2005, 01:39 AM
AND thread.title like 'a%'