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/ ]