Laravel cannot use field named 'status'

Question

$this->model
            ->join('user_credentials', 'upload_conversions.user_id', '=', 'user_credentials.user_id')
            ->select(
                'upload_conversions.id',
                'upload_conversions.status',
                'upload_time',
                'user_credentials.user_id',
                DB::raw('CONCAT(user_credentials.first_name, " ", user_credentials.last_name) as user_name')
            )
            ->where('upload_conversions.status', '!=', 'x')
            ->groupBy('upload_time')
            ->get();

In the above query I cannot seem to use the field "status" in my where clause with Laravel's eloquent.

Please notice the "!=", it shouldn't matter what the string contains. If I change the where to use any other field, the query works like it should.

I cannot seem to find any answers and I cannot believe I'm the first to use a field name "status" in a where clause.

So what am I doing wrong?

UPDATE: The problem is that i'm getting no error, but also no results. Where it should have plenty results. Changing the field in the where gives results..

UPDATE: It is because of NULL values. NULL in SQL should also not be a string so why is this not working? Is this a Laravel bug?

ANSWER:

->where('upload_conversions.status', '!=', 'test')
->orWhereNull('upload_conversions.status')

Really ugly, but this works.

What kind of error you are getting? please post the screenshot too. — FULL STACK DEV, Mar 09 '20 at 12:02

score 1 · Answer 1 · answered Mar 09 '20 at 12:11

1

You should use '<>' instead of '!=' in where clause.

answered Mar 09 '20 at 12:11

ugurdnlr

74
2

Please add some explanation to your answer by editing it, such that others can learn from it – Nico Haase Mar 09 '20 at 13:06

bremg · Answer 2 · 2020-03-09T12:56:59.933

0

->where('upload_conversions.status', '!=', 'test')
->orWhereNull('upload_conversions.status')

Really ugly, but this works.

edited Mar 09 '20 at 12:56

answered Mar 09 '20 at 12:43

bremg

48
5

`NULL` checks using `=` is bad. – nice_dev Mar 09 '20 at 12:48
Please add some explanation to your answer by editing it, such that others can learn from it – Nico Haase Mar 09 '20 at 13:06

nice_dev · Answer 3 · 2020-03-09T13:02:32.217

0

You should be using whereNull to get NULL results.

->where('upload_conversions.status', '!=', 'test')
->orWhereNull('upload_conversions.status')

See this answer for more reference for NULL comparison.

edited Mar 09 '20 at 13:02

answered Mar 09 '20 at 12:50

nice_dev

17,053
2
21
35

Thanks, already did that in my code. This still feels bad though.. – bremg Mar 09 '20 at 12:58
1

@bremg _bad_ for what reason? – nice_dev Mar 09 '20 at 12:58

Laravel cannot use field named 'status'

3 Answers3