Eloquent query

[jimlongo]

I need to check that column 'username' both IS NOT NULL and != ""

What is best

 

->where('username','!=','')
->whereNotNull('username')

OR

->whereNotIn('username',[NULL,''])

 

or something else . . .

 

What do you think?

Edited November 2, 2020 by jimlongo

[jimlongo]

on further though and checking straight MYSQL, you cannot do a query with NULL.  

= NULL 
!= NULL
IN(NULL)
NOT IN (NULL)

will not return any results.

Since Eloquent is a mapping tool to MYSQL queries I'm gonna say that the second proposal above doesn't make sense.  You need to check NOT NULL, and != separately.

Don't know of any way to prove it, other than the fact that ->whereNotIN('field',[NULL]) doesn't work in my code.  

 

[brian!]

I would have thought that you could use...

->where('username','!=','')
->whereNotNull('username')

that wherenotin array wouldn't work with a query builder.

[jimlongo]

Yes, that's what i tried to say in the post above, perhaps rather "ineloquently" 🙂

 

Thanks.