Oracle数据库like和not like使用

select * from iw_user where email not like '%@%' and length(email)=11

查询手机号注册的记录而不是邮箱

 

查询2开头的记录

select * from beyond_pay_offline where amount like '2%'