How to make data selection by first letter yii2?

Question

Yii

Hello, help me, I can’t get into my head anymore (and I don’t know).
You need to select values ​​that start with a letter.
$q = LETTER;
$query = Model::find()->where(['like','name', $q])->orderBy('name ASC')->all();
So he naturally gives me all the meanings where the letter is present. not the first.
Tell me how to do it better?

Answer 1

$query = Model::find()->where('name LIKE :q')->addParams(['q'=>$q . '%'])->orderBy('name ASC')->all();