sql语句中or和in的使用例子

select * from view_users_areas where (username = ? or mobile = ? or workno = ?) and password = ? and status = 1 and roles in (5,9,10,11,12,13) and userclass in (1,2,3,4);