SELECT *
FROM OrderItems
WHERE prod_id LIKE 'BNBG%' or quantity = 100
ORDER BY prod_id ASC