Hello Chris, DELETE FROM users WHERE nickname'<nickame>' or better: DELETE FROM users WHERE uid=<uid> Make sure to flush out the following tables as well: sessions whos_online viewed_stories There are probably a couple more tables that are filled in as well, but I forget which ones; something like a preferences table. -- Cory R. King Chris Schults wrote: > I need to delete a user account, which hasn't posted a story or comment yet. > What is the best way? > > Chris > > -------------------------- > > Chris Schults > Web Production Manager > Grist Magazine > 710 Second Avenue, Suite 860 > Seattle, WA 98104 > Phone: 206-876-2020, ext. 204 > Fax: 253-423-6487 > <http://www.grist.org> > > To sign up for Grist by email, the world's top environmental news served up > with a sense of humor, click here <http://www.grist.org/signup/> or send a > blank email message to <daily-grist-subscribe at lists.grist.org> > > _______________________________________________ > Scoop-help mailing list > Scoop-help at lists.kuro5hin.org > http://lists.kuro5hin.org/mailman/listinfo/scoop-help >