List:General Discussion« Previous MessageNext Message »
From:Bruce Ferrell Date:January 6 2006 2:16pm
Subject:Re: How come this update does not work??
View as plain text  

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
> set 
>
> pixelpost_pixelpost.headline=wp_posts.post_title,pixelpost_pixelpost.datetime=wp_posts.post_date_gmt,pixelpost_pixelpost.body=wp_photos.caption
> where wp_photos.photo like '%pixelpost_pixelpost.headline%' and 
> wp_photos.post_ID=wp_posts.ID;
> 
> 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
Thread
How come this update does not work??Carlos Vasquez5 Jan
  • Re: How come this update does not work??Bruce Ferrell6 Jan