Want to put MySql limit on each where condition -

i want refine mysql condition putting limit on each parameter.

current query

select * product  name "%abc%" or name "%xyz%"  limit 50

i got result having 50 rows both condition. want result on base of each condition such as

select * product  name "%abc%"  limit 50   select * product  name "%xyz%"  limit 50

i want wrap both above queries in 1 got 50 records first query , 50 next one.

you can try use union all

select * product  name "%abc%"  limit 50  union  select * product  name "%xyz%"  limit 50

ITEMscalal