A list of operators on Eloquent's where() method
October 26, 2018
When you use Eloquent's where()
method, by default it will use the =
operator (i.e. ->where('fieldname','value')
will generate ... WHERE
.fieldname
= 'value'...
However you are not limited to just =
. You can do something like this:
<?php
$posts = Post::where("id","!=",123)->get()
Any of the following may be used as the second parameter (and use the third param for the value)
=
, <
, >
, <=
, >=
, <>
, !=
, LIKE
, NOT LIKE
, BETWEEN
, ILIKE
(ILIKE = case insensitive like, I believe this is just for Postgre)