select * from 表名 c where (c.name='110' or c.gonghao='110') and c.state not like '%1%' order by c.id desc;