update table set job='技术支持' where (job like '%技术支持%' or job like '%FAE%') 
and not (job like '%售前%' or job like '%售后%');

记住 and 前面后面都要加括号