如何查询Laravel Eloquent belongsTo关系？

Question

I am studying the Laravel Eloquent Relationships, with different examples. I have a State model and City model, where City belongsTo State and State hasMany City.

As per given code on https://laravel.com/docs/5.7/eloquent-relationships#eager-loading, I successfully queried the states which have cities whose name starts with 'p'. But I am unable to retrieve all those cities whose state names start with 'l'.

This could be a very basic question, but still, I am seeking for help for what goes unsuccessful and why.

Answer 1

Try this:

State::where('name','like','l%')->get();

For querying relationship:

$states= City::whereHas('state', function ($query) {
   $query->where('name', 'like', 'l%');
})->get();