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
peter wrote:
Is
...LIKE '%[img]' + i.image_name + '[/img]%'
what you're looking for?
unfortunately not. i'd tried this without success and even set up some dummy text in a story with *just* the [img]myimage.jpg[/img] text.
still doesn't find it...
kris
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]