i'm having problems trying to write a query that returns a list of images and the stories (if any) that they're associated with. in this case, the story references the image embedded into the story body text in the format [img]myimage.jpg[/img]
SELECT i.id, i.image_name, i.image_width, i.image_height, s.id as story_id, s.title
FROM images i
LEFT JOIN stories s
ON s.body like '[img]' + i.image_name + '[/img]'
WHERE i.image_name like '%$search%'
ORDER by i.image_name
this returns the appropriate images, but doesn't pick up any associated stories (which i *know* exist).
i'm guessing that it's something to do with the ON clause, but i don't understand what's wrong.
many thanks
kris -- kris burford midtempo ltd http://www.midtempo.net
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
