select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Sweetheart Empire Lavender Ruched Chiffon Knee-length Dama Dress
One Shoulder Champagne Dama Dress with Handmade Flower and Belt
Lavender Beaded One Shoulder Chiffon Knee-length Dama Dress
One Shoulder Pleated Pink Chiffon Empire Brush Train Dama Dress
Ball Gown Ruffles and Beading 2013 winter Quinceanera Dresses with Lace up
The Most Popular Ball Gowns Sweetheart Floor-length Quincenera Dresses
Baby Pink Sweetheart Quinceanera Gown with Appliques and Overskirt
Popular Purple Sweet Sixteen Dresses with Embroidery and Pick-ups
Custom Made Strapless Embroidery Quinceanera Dress with Overskirt
Exquisite Halter Embroidered Olive Green Dress for Quinceaneras
Elegant Hand Made Flowers Jacket in Brown
Champagne Long Sleeves Jacket With Lace
Wonderful Spring Green Paillette Sweet 16 Dress with Appliques
Modest Purple Sweetheart Appliques Quinceanera Gown with Jacket
Fuchsia Ball Gown Dresses for Sweet15th with Beading in Taffeta
Chic Flower Decorate 2012 Lilac Sweet 15 Gown Tiered
Lovely Taffeta Open Front Jacket in Champagne
Hot Pink Beading Lace Hot Sale Wraps for 2014
Lavender Strapless Ball Gown Sweet 15 Dresses with Beading
White Ball Gown Strapless Pink Sequins Sweet Sixteen Dresses
Beading Strapless Ball Gown Sweet 15 Dresses in Light Yellow
A-line Sweetheart Embroidery and Beading Baby Blue Sweet 15 Dresses
Simple Beading Hand Made Flower Wra
Cheap Beading Organza White Wraps for Summer
Quinceanera Dress Strapless with Embroidery and Beading in Baby Blue
Baby Pink Sweetheart Quinceanera Dress with Beaded Sweetheart
A-line Strapless Appliques Paillette Sweet Sixteen Dresses in Blue
Lace Scoop Beading Organza Shawls for Spring
White Organza Beading Shawls for Summer
Top Selling Open Front Wraps in White