Selecting rows if they are NULL or NOT NULL -

Category: Eloquent ORM Topic: Eloquent Builder Created: 3 years ago

Following snippet will help you to get rows from a table which are either NULL or NOT NULL

// rows where post_url is null
Post::select(['id','title','post_url'])->whereNull('post_url')->get()
// rows where post_url is not null
Post::select(['id','title','post_url'])->whereNotNull('post_url')->get()

Last Edited: 3 years ago

Selecting rows if they are NULL or NOT NULL

Related Posts

Using selectRaw with aggregate function, where, orderBy, groupBy, take and get

Using WhereIn

Updating multiple rows

How to delete all the rows in a table

How to use count with where condition

How to get names in list instead of associated array ( id as key and name as value )

Using Like

Checking what query is run with eloquent

Using orWhere

How to use condition in query dynamically

Using dynamic condition under auth check and request query

What is Query Builder?

Using "with" in eloquent query

Getting last inserted id

Selecting last row of a table

How to write multiple AND queries inside OR query using closure

Returning rows where a column is between two values

How to use whereHas to retrieve rows based on existence of relationship

Using withAggregates in Eloquent way

Selecting fields inside eager loading method "with"

Quick way to save or update post with one liner of eloquent code

Using model observer - a separate class to observe model changes and run desired logic

Changing model values using mutators before saving in database

Using parameters in find() method

Using findorFail() and firstOrFail() method

Using whereDate, whereYear, whereMonth, whereDay and whereCreatedAt for dates

Using brackets to specify two or more where clauses into its own where function in eloquent

Using local scope in eloquent

Using global scope in eloquent

How to use eloquent when - more elegant way of using if statement