有会Medoo的吗，求个语句

Question

select * from table where (title like '%1%' and content like '%2%') and s=1 and n=1 order by id desc

请问这样的语句用medoo该怎么写？

我这样写报错

$datas = $database->select("table","*",array('AND'=>array('LIKE'=>array('AND'=>array('title'=>'1','content'=>'2')),'s'=>1,'n'=>1),"ORDER"=>'id DESC'));

Answer 1

发现0.9.7版才支持[~]写法，之前的版本都不支持。。。

Answer 2

方案1:

$where = array(
	'AND' => array(
		'title[~]' => '%1%',
		'content[~]' => '%2%',
		's' => 1,
		'n' => 1
	),
	'ORDER' => 'id DESC'
);
$db->select('table', '*', $where);

方案2:

$db->query("select * from table where (title like '%1%' and content like '%2%') and s=1 and n=1 order by id desc");

顺便说一句,先把有索引的条件(非like)放到前面,能够加快查询速度