consultas - wherein laravel eloquent

Laravel-Eloquent: Advanced Wheres

Question

Intento crear algo como esto usando Eloquent. Sin embargo, estoy teniendo problemas con la cláusula o.

SELECT * FROM table WHERE column1 = 1 AND column2 = 2 AND (column3 LIKE $search_term.''%'' OR column4 LIKE $search_term.''%'') ORDER BY column1;

Esto es lo que tengo:

$query = DB::table(''table'')
->where(''column1'', ''='', 1)
->where(''column2'', ''='', 2)
->orderBy(''column1'', ''asc'');
$results = App/Table::where(function ($query) use ($search_term) {
$query->where(''column3'', ''like'', $search_term.''%'');
})->orwhere(function ($query) use ($search_term) {
$query->where(''column4'', ''like'', $search_term.''%'');
});

Answer 1

Su consulta debería verse así:

$query = DB::table(''table'')
->where(''column1'', 1)
->where(''column2'', 2)
->where(function ($q) use ($search_term) {
$q->where(''column3'', ''like'', $search_term.''%'')
->orWhere(''column4'', ''like'', $search_term.''%'');
})
->orderBy(''column1'', ''asc'')
->get();

Answer 2

También puede usar la cláusula whereRaw :

App/Table::where(''column1'', 1)
->where(''column2'', 2)
->whereRaw("(column3 LIKE $search_term.''%'' OR column4 LIKE $search_term.''%'')")
->orderBy(''column1'', ''asc'');

Answer 3

$results = App/Table::select(''*'')
->where(''column1'', 1)
->where(''column2'', 2)
->where(function ($query) use ($search_term) {
$query->where(''column3'', ''like'', $search_term.''%'')
->orWhere(''column4'', ''like'', $search_term.''%'')
})
->orderBy(''column1'', ''asc'')
->get();