使用or满足两个任意条件

select prod_id, quantity
from OrderItems
where quantity = 100 or prod_id like 'BNBG%'