i am developing a new forum site which shall be a "subset" of an existing forum.

i want to mass delete all *topics* from the database that do not contain specified keywords.

clearly, this will require some mysql magic, with at least one JOIN.

can anyone point me in the right direction? guarantees not required; i know the warranty is null and void once i start stuffing around like this! i'm all nicely backed up, so i can afford a few catastophies ...



JakChat.com -- Forums for Indonesia's English-speaking community
Ubuntu-Indonesia.com -- Forums for Indonesia's Ubuntu Users