Laravel 4, eloquent - between statement and operators
eloquent, laravel, mysql, php, query-builder
Solution
This should do it...
`$results = my_model::select('*')->whereRaw("$val between col1 and coL2")->get();`
I think this is pretty safe, but you may need to clean `$val` first.
Problem
There is a query I use to run in mysql : ``` select * from my_table where $val between col1 and coL2; ``` It works fine, but with laravel 4, the only way to make that query is to have something like ``` my_model::where('col1','>=',$val)->where('col2','<=',$val) ``` This way doesn't seem to work, because I don't have the same result when using the usual "select * ..." Any idea ? Just to clarify my request : In my case i dont have "...where column between value1 and value2" but "where value between commun" So it seems to me that i can't use "wherebetween"