Hi,
Good day!
I encountered difficulties in checking of the data is like on the data from my table.
I have table
wms_picking
and I have lot_number field and value = ‘LO130318001-LO130318002’ and item_code = ‘MAT-CHE-0010’
then I have variable:
$lot_number = ‘LO130318001LO130318002’;
$mat_code = ‘MAT-CHE-0010’;
I created query:
select s.sr_id, p.item_code, p.lot_number from sr_chemicals AS s JOIN wms_picking AS p ON (s.sr_id = p.sr_id)
WHERE p.item_code = ‘$mat_code’ and p.lot_number LIKE ‘%$lot_number%’;
select s.sr_id, p.item_code, p.lot_number from sr_chemicals AS s JOIN wms_picking AS p ON (s.sr_id = p.sr_id)
WHERE p.item_code = ‘MAT-CHE-0010’ and p.lot_number LIKE ‘%LO130318001LO130318002%’;
and I got no result, but I just want to get the result of lot_number field field and value = ‘LO130318001-LO130318002’ and item_code = ‘MAT-CHE-0010’.
Any help is highly appreciated.
Thank you so much.