select * from products where pro_name like '%a%line%' or pro_des like '%a%line%'union all select * from products where (pro_name like '%a%' or pro_des like '%a%') or(pro_name like '%line%' or pro_des like '%line%') and (pro_name not like '%a%line%' or pro_des not like '%a%line%')
Taffeta One Shoulder Royal Blue Dama Quinceanera Dress with Pleat
Chiffon Light Pink One Shoulder Quinceanera Dama Dress with Ruches
Chiffon Light Yellow Dama Quince Dress with Hand Made Flowers
Halter Top Spring Green Knee-length Chiffon Dama Dress 2014
The Most Popular Ball Gowns Sweetheart Floor-length Quincenera Dresses
Elegant Hand Made Flowers Jacket in Brown
Champagne Long Sleeves Jacket With Lace
Wine Red One Shoulder Chiffon Knee-length Dama Dress for Cheap
Red V-neck Knee-length Quinceanera Dama Dress with Pleat in Satin
Wine Red Dama Quinceanera Dress with Straps in Chiffon and Satin
Apple Green V-neck Chiffon Quinceanera Dress for Dama with a Sash
Lovely Taffeta Open Front Jacket in Champagne
Brand new Organza Beading and Ruffles Jacket in Blue
Sweetheart Watermelon Dama Dress with Ruches and a Brush Train
Brown Mini-length Dama Dress with Spaghetti Straps in Chiffon
Satin Light Blue Dama Dress with a Brush Train and a Sash
Chiffon V-neck Lilac Dama Dress With Ruches in Knee-length
Hot Pink Beading Lace Hot Sale Wraps for 2014
Simple Beading Hand Made Flower Wra
Cheap Beading Organza White Wraps for Summer
Olive Green Knee-length Chiffon Sweet 15 Dama Dress with a Sash
Chiffon White Sweet 15 Dama Dress with Ruches in Knee-length
Roes Pink V-neck Mini-length Dama Dress with Ruches in Chiffon
Chiffon V-neck Roral Blue Dama Dress With Ruches and a Sash
Lace Scoop Beading Organza Shawls for Spring
White Organza Beading Shawls for Summer
Turquoise Knee-length Dama Dress with a Bow and Spaghetti Straps
Black Chiffon Dama Dress with Ruches and Spaghetti Straps
One Shoulder Light Yellow Dama Dress with Ruches in Chiffon
Violet Red Chiffon Dama Gown with Rushes and a Hand Made Flower