select * from OrderItems where quantity =100
union all
select * from OrderItems where prod_id like "BNBG%"
order by prod_id

知识点：
1 union（all）的用法