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


Reply via email to