ThinkPHP 5.1 中的高级查询表达式技巧

// User 模型类namespace appcommonmodel;use thinkModel;class User extends Model{    // 指定表名    protected $table = 'user';}

// 查询年龄等于 25 岁的用户$userList = User::where('age', 25)->select();

// 查询年龄不等于 30 岁的用户$userList = User::where('age', 'neq', 30)->select();

// 查询年龄大于 18 岁的用户$userList = User::where('age', 'gt', 18)->select();// 查询年龄小于 40 岁的用户$userList = User::where('age', 'lt', 40)->select();

// 查询年龄在 20 到 30 岁之间的用户$userList = User::where('age', 'between', [20, 30])->select();

// 查询年龄不在 30 到 40 岁之间的用户$userList = User::where('age', 'not between', [30, 40])->select();

// 查询名字包含 "张" 的用户$userList = User::where('name', 'like', '张%')->select();

// 查询年龄在 25、30、35 岁之一的用户$userList = User::where('age', 'in', [25, 30, 35])->select();

// 查询没有邮箱地址的用户$userList = User::where('email', 'null')->select();

// 查询有邮箱地址的用户$userList = User::where('email', 'not null')->select();