一、普通查詢方式
a、字元串
$arr=$m->where("sex=0 and username='gege'")->find();
b、數組
find()隻能查詢一條,查詢多條用select();
注意:這種方式預設是and的關系,如果使用or關系,需要添加數組值 $data['_logic']='or';
二、表達式查詢方式
$data['id']=array('lt',6); $arr=$m->where($data)->select();
EQ 等于 NEQ不等于 GT 大于 EGT大于等于 LT 小于 ELT小于等于
LIKE 模糊查詢 $data['username']=array('like','%ge'); $arr=$m->where($data)->select();
NOTLIKE $data['username']=array('notlike','%ge%'); //notlike中間沒有空格 $arr=$m->where($data)->select();
注意:如果一個字段要比對多個通配符 $data['username']=array('like',array('%ge%','%2%','%五%'),'and');//如果沒有第三個值,預設關系是or關系
$arr=$m->where($data)->select();
BETWEEN $data['id']=array('between',array(5,7)); $arr=$m->where($data)->select(); //SELECT * FROM `tp_user` WHERE ( (`id` BETWEEN 5 AND 7 ) ) $data['id']=array('not between',array(5,7));//注意,not 和 between中間一定要有空格
IN $data['id']=array('in',array(4,6,7)); $arr=$m->where($data)->select(); //SELECT * FROM `tp_user` WHERE ( `id` IN (4,6,7) )
$data['id']=array('not in',array(4,6,7)); $arr=$m->where($data)->select(); //SELECT * FROM `tp_user` WHERE ( `id` NOT IN (4,6,7) )