Carlos Vasquez wrote:
> How come this doesn't work?
> Wp_photos.photo = IMG_1234.JPG
> Pixelpost_pixelpost.headline = /this/path/to/directory/IMG_1234.JPG
> So I need to just match the latter-bit of the file.
> update pixelpost_pixelpost,wp_posts,wp_photos
> where wp_photos.photo like '%pixelpost_pixelpost.headline%' and
> I get zero rows returned, 0 updated, etc.
> Any ideas would be appriciated?
> thanks in advanced
I'd say the where clause isn't being matched. Try a select with the
same where clause and see what you get back