gistfile1.sql

update drupal_users
set mail = "seley@aarweb.org"
where mail not like '%@aarweb.org'
and mail not like '%@hallwaytech.com';

update drupal_users
set mail = 'ssnider@aarweb.org'
where name in ('Z22505', 'S00304', 'Z37527', 'Z21587', 'Z38940', 'Z34751');

update drupal_users
set mail = 'sherrick@aarweb.org'
where name in ('S02013', 'L00085', 'Z37692', 'T11080', 'V00167', 'Z39053', 'Z30093');

update drupal_users
set mail = 'rpuckett@aarweb.org'
where name in ('R46175', 'Z25527', 'Z40005', 'Z20245', 'Z26748', 'S78400', 'V02725');