mysql直接字段比较筛选数据

select * from xxx where `field1`= `field2`

select * from xxx where `field2`!= `field3`