SET @Date = '2018-10-31';
SET @ShippingMethodID = 142;

SELECT *
FROM trackingnumbers
WHERE ShipDate >= CONCAT(@Date, ' 00:00:00')
AND ShipDate <= CONCAT(@Date, ' 23:59:59')
AND ShippingMethodID = @ShippingMethodID;