XF 1.5 email scrubbing

[Laetos]

how can i automate this

 UPDATE xf_user SET user_state = 'email_bounce' WHERE email = 'example@example.com';

to go through a csv list containing only the bounced email addresses?

 

[Paul B]

It would require a custom script/development.

Why doesn't the built in bounce processing work?

 

[Laetos]

I was going to switch over to SES with my mails and wanted to clean my list up before AWS shuts me down, anyways i have this list as csv now.

It would require a custom script/development.

I do have console access to the host and and created a copy of the XF DB for testing purposes, i could run phpmyadmin if that makes things easier, am i really the first who needs this?
Searches so far indicate something like importing the csv into a temp table and going for there but i thought i ask here first before i spent more time trying to learn how to do mysql query's.

 

[Laetos]

i dived into the magic lands of sed & awk and got it done aka find & replace then copy pasta into mysql