Multiple Values check and then return SQL -

Multiple Values check and then return SQL -

suppose have table columns: name , pizzaeaten want names have eaten both pepperoni , mushroom i.e. not include ones have eaten pepperoni....or have eaten mushroom. have eaten both pepperoni , mushroom

you'd have following:

select name mytable pizzaeaten = 'pepperoni' , name in ( select name mytable pizzaeaten = 'mushroom' )

by means of subquery can obtain results both of individual pizzaseaten.

sql