Sorry, my mistake, I think you need CONCAT( '%[img]', i.image_name, '[/img]%' )
PB ----- Original Message ----- From: kris burford To: Peter Brawley ; [EMAIL PROTECTED] Sent: Friday, March 12, 2004 8:06 AM Subject: Re: query reference help > 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
