The Trouble With Quotes: Drupal

I'm revamping some of the old site, as I have upgraded to Drupal 4.5.0, and as a few regulars will know - I have some quotes that are done randomly on the top left of the page. It's a neat thing that I enjoy, especially reading what I write and thinking of it in the context of the quote.

So I downloaded the latest Quotes module, and followed the instructions. It's plain enough, and if you're upgrading you have to import all the quotes. Yeah, no kidding. But no big deal, I did that. It does this through the standard 'create content' area, and I screwed up. I promoted the whole thing to the front page.

So my options were:

(1) go through each &*%^#&@ node and &^%^%$^#$ uncheck ^&%$#&$% 'Promoted to front page' on *%&@^$% single *&%^&%#$@ one of 756 of these *&*(@^$#*& things.

(2) Find a better way.

Here's the better way:

UPDATE node SET promote = 0

WHERE title = 'KnowProseQuotes';

SQL to the rescue. If you don't know how to deal with SQL... happy clicking.

Replace 'KnowProseQuotes' with the name of the title you used to import the little bastards. It will lengthen your life. On to other updates...