' ]+@[^@%*<>' ]{2,255}\.[^@%*<>' ]{2,5}", trim(arguments.memberBean.getEmail())) neq 0> insert into tmailinglistmembers (mlid,email,siteid,fname,lname,company,isVerified) values ( , , , , , , ) Select mlid,siteid,email,fname,lname,company,isVerified from tmailinglistmembers where siteid= and email= ]+@[^@%*<> ]{2,255}\.[^@%*<> ]{2,5}", trim(arguments.memberBean.getEmail())) neq 0> update tmailinglistmembers set fName= ,lName= ,company= ,isVerified= where siteid= and email= ]+@[^@%*<> ]{2,255}\.[^@%*<> ]{2,5}", trim(arguments.memberBean.getEmail())) neq 0> delete from tmailinglistmembers where email= and siteid= ]+@[^@%*<> ]{2,255}\.[^@%*<> ]{2,5}", trim(arguments.memberBean.getEmail())) neq 0> delete from tmailinglistmembers where mlid= and email= and siteid=