select * from s_user t where t.user_name like '%z%' 查询、删除某个字段是空空的 select * from s_user t where t.user_pwd is null