Yii SQL 语句会出现转义符 ` [ 2.0 版本 ]

一般我都是把内置函数放到select的字段里面,在对结果进行处理。可以这样试试

$w = 'xxxx';
        echo WeixinCourse::find()
            ->select(["id","if(instr(username,'{$w}') >0,1,0) as temp"])
            ->andWhere(['or', ['like', 'name', $w], ['like', 'description', $w]])
            ->orderBy("temp desc,id desc")
            ->createCommand()->getRawSql();
        die;

use yii\db\Expression;

原来的
`$w='xxxx';
echo WeixinCourse::find()

->select('id')
->andWhere(['or', ['like', 'name', $w], ['like', 'description', $w]])
->orderBy("if(instr(name,'{$w}') >0,1,0) desc,id desc")
->createCommand()->getRawSql();die;`

改为
`$w='xxxx';
echo WeixinCourse::find()

->select('id')
->andWhere(['or', ['like', 'name', $w], ['like', 'description', $w]])
->orderBy(new Expression（"if(instr(name,'{$w}') >0,1,0) desc,id desc"))
->createCommand()->getRawSql();die;`

仅供参考：
WeixinCourse::find()
->where(['LIKE', 'name', $xxxx.'%', false])//%这样放，可以使name索引（设置了索引的话）生效
->andWhere(['status'=>1])
->orWhere(['LIKE', 'description', $xxxxX.'%', false])//%这样放，可以使description索引（设置了索引的话）生效
->orderBy("if(instr(name,'{$w}') >0,1,0) desc,id desc")
->all();