the definition says whereBetween($column_name, [$value1, $value2]). so u cant have your input as the first parameter.

so for you to get what you want either use raw or

DB::table('table1') ->where('column1', '>=', $input) ->where('column2', '<=', $input) ->first()

zam3858 said:

the definition says whereBetween($column_name, [$value1, $value2]). so u cant have your input as the first parameter.

so for you to get what you want either use raw or

DB::table('table1') ->where('column1', '>=', $input) ->where('column2', '<=', $input) ->first()

Thanks.. But not for the query builder represent all sql queries?