SELECT *,
       Substring(Substring_index(productnote, '|', -1), 1, 3) AS CodeAfterPipe
FROM   orderdetails
WHERE  qtyonhold = 0
       AND  (ProductNote LIKE 'HRZ 11012025%' OR ProductNote LIKE 'MRC 11012025%')