in simple terms:
Match is use insted of writing multiple where conditions or if conditions
where product='a' and product ='b' and product='c';
by using match we can write like
in the same way
wild match is to use match with wild characters %
and mix match is case insensitive
and like is instead of multiple where its same as match.