By v8powerage on

I want unpublish all nodes of one content type, what query should I make?

⋅ Categories: Drupal 6.x

Comments

bibstha’s picture

bibstha commented

Not entirely sure but i suspect the "status" field in the node table represents whether a node is published or not.

So, UPDATE node SET status=0 WHERE type='content_machine_name'

Cheers

--
http://bibekshrestha.com.np

v8powerage’s picture

v8powerage commented

Thank You very much, perhaps You'll find some solution to my new task ;-) http://drupal.org/node/499634