thinkphp的普通查询与表达式查询

一、普通查询方式

a、字符串:$arr=$m->where("sex=0 and username=‘gege‘")->find();//字符串需要加引号

b、数组

1. $data[‘sex‘]=0;?
2. $data[‘username‘]=‘gege‘;?
3. $arr=$m->where($data)->find();//传上一个数组进行查询，这种方式默认是and（并且）的关系?

注意:如果使用or关系，需要添加数组值

1. $data[‘sex‘]=0;?
2. $data[‘username‘]=‘gege‘;?
3. $data[‘_logic‘]=‘or‘;//对数组添加_logic赋值为or（或者）关系?

?

二、表达式查询方式

1. $data[‘id‘]=array(‘lt‘,6);//数组的元素依然是数组?
2. ???????$arr=$m->where($data)->select();?
3. ???????EQ?等于??//大小写没有关系?
4. ???????NEQ不等于?
5. ???????GT?大于?
6. ???????EGT大于等于?
7. ???????LT?小于?
8. ???????ELT小于等于?
9. ???????LIKE?模糊查询?
10. ???????????$data[‘username‘]=array(‘like‘,‘%ge%‘);//like加通配符查询?
11. ???????????$arr=$m->where($data)->select();//所有包含ge的都查询出来?
12. ???????NOTLIKE不包含?
13. ???????????$data[‘username‘]=array(‘notlike‘,‘%ge%‘);?//notlike中间没有空格?
14. ???????????????$arr=$m->where($data)->select();?
15. ?
16. ???????????注意：如果一个字段要匹配多个通配符?
17. ???????????$data[‘username‘]=array(‘like‘,array(‘%ge%‘,‘%2%‘,‘%五%‘),‘and‘);//如果没有第三个值and，默认关系是or关系?
18. ???????????$arr=$m->where($data)->select();//或者(or)能查到其中一个值就行?
19. ?
20. ???????BETWEEN?
21. ???????????$data[‘id‘]=array(‘between‘,array(5,7));?
22. ???????????$arr=$m->where($data)->select();?
23. ???????????//SELECT?*?FROM?`tp_user`?WHERE?(?(`id`?BETWEEN?5?AND?7?)?)?
24. ???????????$data[‘id‘]=array(‘not?between‘,7));//注意，not?和?between中间一定要有空格?
25. ???????????$arr=$m->where($data)->select();?
26. ???????IN?
27. ???????????$data[‘id‘]=array(‘in‘,array(4,6,7));?
28. ???????????$arr=$m->where($data)->select();?
29. ???????????//SELECT?*?FROM?`tp_user`?WHERE?(?`id`?IN?(4,7)?)?
30. ?
31. ???????????$data[‘id‘]=array(‘not?in‘,7));?
32. ???????????$arr=$m->where($data)->select();?
33. ???????????//SELECT?*?FROM?`tp_user`?WHERE?(?`id`?NOT?IN?(4,7)?)