Re: [support] MySQL noob: Update images to gallery tid

That was badly phrased at the end. I meant: I think that makes sense, but I can't figure out the syntax.

Any pointers gratefully appreciated.

On 01 Nov 2011, at 5:33 PM, Jeff Brown wrote:

Hope you'll pardon my absolute lack of knowledge of SQL and give me a little clue or 2.

I'm retroactively changing the photos layout on a site to Views Gallery, and need to update a couple of image nodes to the Term "gallery".

Could do it manually, I guess, but I'd really love to know this trick.

So I have nid 1,2,3,4, etc. that need to have the gallery tid = '1' (for argument's sake).

Therefore I need to update the 'term_node' table - and INSERT where nid = 1,2,3,4 tid = '1'

I think that makes sense?

Thanks. :)

[ Drupal support list | http://lists.drupal.org/ ]