Re: sql to duplicate records with modified value ?

On Mon, March 29, 2010 9:54 pm, Joel Heenan wrote:
> Assuming your table is called "users" and your columns are "user" and
> "maildir":
> INSERT INTO users(user,maildir) SELECT REPLACE(user,'@','+spam@') AS
> user, CONCAT(maildir,'.spam') AS maildir FROM users;

thanks, Joel, worked good
(except for the one record I already inserted by hand...)

so I'll be able to deliver spam mail to individual recipients' spam folder



-- 
Voytek

-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html