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 + '[/i
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
> SE
Kris,
Is
...LIKE '%[img]' + i.image_name + '[/img]%'
what you're looking for?
PB
- Original Message -
From: Kris Burford
To: [EMAIL PROTECTED]
Sent: Friday, March 12, 2004 7:03 AM
Subject: query reference help
hi
i'm having problems trying to write a query that retu
