gistfile1.sql

update drupal_users
set mail = "[email protected]"
where mail not like '%@aarweb.org'
and mail not like '%@hallwaytech.com';

update drupal_users
set mail = '[email protected]'
where name in ('Z22505', 'S00304', 'Z37527', 'Z21587', 'Z38940', 'Z34751');

update drupal_users
set mail = '[email protected]'
where name in ('S02013', 'L00085', 'Z37692', 'T11080', 'V00167', 'Z39053', 'Z30093');

update drupal_users
set mail = '[email protected]'
where name in ('R46175', 'Z25527', 'Z40005', 'Z20245', 'Z26748', 'S78400', 'V02725');