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)
(ILIKE = case insensitive like, I believe this is just for Postgre)