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?
$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?