Easy query that should not give null

$product = Product::where('serial', $serial)->orWhere('mfg_serial', $serial)->first();

why this query yields null where I have the serial and I am sure of that

Level 55

@lifesound if you have it - it should works. It means either you have incorrect value in $serial OR you DO NOT have record with this serial

Use any db client to check the database directly with the query

select * from products where `serial` = "put_serial_here" or `mfg_serial` = "put_serial_here"

Level 17

@SilenceBringer please check my screenshots down

Level 55

@lifesound so, you mfg_serial is always null. Can you show the row which contains search value?

Level 51

Please copy the record from the database and post it here. Also please post the result of dd($serial)

Level 17

removed photo for production purposes

Level 17

weird it was my SQL problem and after restart it worked

Level 5

@lifesound sound like some caching issue, you might want to disable it or something might work unexpectedly

Best Answer

Level 17

after a hard night it was a space problem there were a little space that’s not trimmed

Please or to participate in this conversation.