Solution
Since they both have a name column, MySql doesn't know which to use.
Use the alias because your query doesn't specify which alias to use for the name column.
You can update your query like
->where('posts.name', 'like', '%' . $query . '%')
Solution selected by
@ajax30
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast