thinkphp增删改查的where条件句的一些例子

M('sp_info')->where(array('name' => $sptm['name']))->save($data);

$cx= $s ->where("code='%s'",$tm['code']) -> find();

$User->where('score=100')->limit(3)->save(array('level'=>'A'));

$Model->field('id,nickname as name')->select();

$Model->field('id,SUM(score)')->select();

$Model->field(array('id','title','content'))->select();

$Model->field('title,email,content')->save($data);

$User->where('status=0')->order('create_time')->limit('5')->delete();