thinkphp는 퍼지 쿼리 예제와 같은 구현

$User = M("User"); // 实例化User对象
$User->where('type=1 AND status=1')->select();

SELECT * FROM think_user WHERE type=1 AND status=1

$User = M("User"); // 实例化User对象
$condition['name'] = 'thinkphp';
$condition['account'] = 'thinkphp';
$condition['_logic'] = 'OR';
// 把查询条件传入查询方法
$User->where($condition)->select();

SELECT * FROM think_user WHERE `name`='thinkphp' OR `account`='thinkphp'

$userForm=M('user'); 
$where['name']=array('like','php%');
$userForm->where($where)->select();

name like 'php%'

$where['name']=array('like',array('%php%','%.com'),'OR');

name like '%php%' or name like '%.com'

$where['name']=array(array('like','%a%'),array('like','%b%'),array('like','%c%'),'php','or');

(`name` LIKE '%a%') OR (`name` LIKE '%b%') OR (`name` LIKE '%c%') OR (`name` = 'php')

$where['_string']='(name like "%php%")  OR (title like "%php")';

name like '%jb51%' or title like '%php'