你这没有任何效果呀,where条件根本不成立啊......
试试,
update userinf SET 科技协会=iif("username='110342120' or username='110341331'","部长","干事") WHERE username in ('120341304','120341206','120341146','110342120','110341331')
祝你成功!