How can I use a like query and limit to the first character only for example my code below works however it does it for all characters for example if an item was called end it would appear in e, n & d rather than just e the starting character/letter.
Current Query/Code
public function actionAlphabet($id)
{
$this->layout = 'directory';
$query = Directory::find()
->where(['LIKE', 'name', $id]);
$dataProvider = new ActiveDataProvider([
'query' => $query
]);
return $this->render('index', [
'dataProvider' => $dataProvider,
]);
}