Update db_spid_list set scan_out_time = CURRENT_TIMESTAMP , despatch_order_id = '', despatch_product = '', Despatch_Consignment_ID = '',  Despatch_Shipment_ID = '' WHERE auod_shipment_id = '' and (replace(replace((replace(barcode, '''', '')), '',''), '-','') like '%%'  or ( REPLACE(REPLACE(IF(RIGHT(barcode, 3) = '.0;', REPLACE(barcode, '.0', ''), barcode), '''', ''), '', '') like '%%')