Skip to content

Instantly share code, notes, and snippets.

Created October 21, 2016 12:49
Show Gist options
  • Save anonymous/1226bda5334674b0dd0c768e46179bae to your computer and use it in GitHub Desktop.
Save anonymous/1226bda5334674b0dd0c768e46179bae to your computer and use it in GitHub Desktop.
public function buscaParceiro(Request $request){
$string = $request->get('pesquisa');
$parceiro = DB::table('usuario')
->where('filho_type', '=', "CompraSerrana\Parceiro")
->join('pessoa', 'pessoa.nome', 'LIKE', "%$string%")
->get();
return view('painel/parceiro/listagem', compact('parceiros'));
}
SQLSTATE[23000]: Integrity constraint violation: 1052
Column 'filho_type' in where clause is ambiguous
(SQL: select * from `usuario` inner join `pessoa` on `pessoa`.`nome` LIKE `%peixe%` where `filho_type` = CompraSerrana\Parceiro)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment