谁一开始就是大神?

如果将这条sql语句转换成YII的查询[2.0]

SELECT * FROM `workbasicinfo` WHERE worktitle like '%11%' and worktag like '%22%'and (worktitle like '%33%' or worktag like '%33%')  

我现在写的是这样的:

 $query = Worksinfo::find()
			->andFilterWhere(['like', 'workid', $this->workid])
			->andFilterWhere(['like', 'makerid', $this->makerid])
			->andFilterWhere(['like', 'worktitle', $this->worktitle])
			->andFilterWhere(['like', 'worktag', $this->worktag])
			->andFilterWhere(['like', 'makername', $this->makername])
			->asArray();
赞(0) 打赏
未经允许不得转载:菜鸟之家 » 如果将这条sql语句转换成YII的查询[2.0]

评论 抢沙发

登录

找回密码

注册