Duane Hill wrote: > delete from bayes_token where id = (select id from bayes_vars > where username = '[EMAIL PROTECTED]'); ... > delete from bayes_seen where id = (select id from bayes_vars where > username = '[EMAIL PROTECTED]'); > > delete from bayes_expire where id = (select id from bayes_vars > where username = '[EMAIL PROTECTED]'); > > delete from awl where username = (select username from bayes_vars > where username = '[EMAIL PROTECTED]'); > > Then, finally removing the account from bayes_vars: > > delete from bayes_vars where username = '[EMAIL PROTECTED]'; >
Nitpick mode on: Changing "id =" to "id in" will save you some errors in corner cases where the username is no longer in bayes_vars... delete from bayes_(token|seen|expire) where id in (select id from bayes_vars where username = '[EMAIL PROTECTED]'); The awl deletion can be simplified too: delete from awl where username = '[EMAIL PROTECTED]'; -- Matthew.van.Eerde (at) hbinc.com 805.964.4554 x902 Hispanic Business Inc./HireDiversity.com Software Engineer
