How to promote nodes to front page using MySQL command line What is the command to promote unpromoted nodes to front page using MySQL command line? I want to promote 200 nodes at once. The node type is "story."
UPDATE node SET promote=1 WHERE type="story" AND promote=0 LIMIT 200;