How do i return data where that contain empty string instead of NULL in laravel

Question

I want to get my data from database where one of my attribute was empty string instead of null....but my code return all data where NULL and empty string combined...here is my code

public function findAllPersons2(){
        return $this->where('pi_person_type','3')
                     ->where('pi_vendor_id','!=' , '')
                    ->orderBy('pi_name', 'asc')
                    ->get();
    }

mrhn · Accepted Answer · 2020-02-14 08:42:31Z

1

Your code are using an not equal to an empty string condition. To retrieve all persons where pi_vendor_id's is empty, do the following where condition.

->where('pi_vendor_id', '=', '')

answered Feb 14, 2020 at 8:42

mrhn

19.1k6 gold badges31 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Adam Fiqrie Putra Over a year ago

Hi...i already try but more worse it does not return anything of my data

mrhn Over a year ago

Have you tried removing where('pi_person_type','3') to see if it returns data then? and are you sure that the field is actually empty?

Adam Fiqrie Putra Over a year ago

my bad sir i call wrong attribute actually ...thanks for your time

Dilip Hirapara · Accepted Answer · 2020-02-14 08:46:33Z

1

Try as below.

$this->where('pi_person_type','3')
                     ->where(function($q){
                         $q->whereNull('pi_vendor_id')->orwhere('pi_vendor_id','');
                     })

                    ->orderBy('pi_name', 'asc')
                    ->get();

answered Feb 14, 2020 at 8:46

Dilip Hirapara

15.4k3 gold badges34 silver badges56 bronze badges

Comments

Niklas · Accepted Answer · 2020-02-14 08:48:25Z

1

This code will also work:

->where('pi_vendor_id', '')

For convenience, if you want to verify that a column is equal to a given value, you may pass the value directly as the second argument to the where method.

https://laravel.com/docs/6.x/queries#where-clauses

answered Feb 14, 2020 at 8:48

Niklas

1,8241 gold badge9 silver badges8 bronze badges

Collectives™ on Stack Overflow

How do i return data where that contain empty string instead of NULL in laravel

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related