select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')

Satin Light Blue Dama Dress with a Brush Train and a Sash

Olive Green Knee-length Chiffon Sweet 15 Dama Dress with a Sash

Baby Pink Halter Top Column Floor-length Dama Dress in Satin

Column Strapless Dama Dress in Lilac with Belt and Ruches

Pink Strapless Empire Ankle-length Chiffon Dama Dress with Sash

Spaghetti Straps Apple Green Column Brush Train Dama Dress

Baby Blue Halter Chiffon Dama Dress with Ruches and Ruffles

Spaghetti Straps Black Sash Knee-length 2013 White Dama Dress

Straps V-neck Orange Ruched and Ruffled Knee-length Dama Dress

Spaghetti Straps Royal Blue A-line Mini-length Ruched Dama Dress

A-line Dark Green Strapless Ruche Chiffon Dama Dress Knee-length

Spaghetti Straps Yellow Column Ankle-length Dama Dress With Bow

V-neck Peacock Blue Empire Mini-length Dama Dress with Ruches

Simple Baby Pink Strapless Ruched Floor-length 2013 Dama Dress

Spaghetti Straps Baby Pink Tea-length Dama Dress With Sash

Black Empire Strapless Knee-length Prom Dresses For Dama with Pink Sash

Teal Empire Straps Knee-length Chiffon Ruching Damas Dresses For Quince

A-line Strapless ea-length Lace with Purple Bow Dresses For Damas

White and Pink A-line Scoop Mini-length Formal Dresses For Dama

Damas Dresses Black and White One Shoulder Floor-length

Modern Red One Shoulder Chiffon Ruched Prom Dresses for Dama

Baby Pink Straps Tea-length Chiffon Dama Dresses with Hand made Flower

Princess Off the Shoulder Prom Dress with Appliques in Organza

A-line One Shoulder Prom Dress for Quince with Hand Made Flowers

Taffeta and Tulle Quince Dress in Teal and White with Floor-length

Multi-color Sweetheart Sweet 15th Dress with Ruffles and Appliques

White and Olive Green Ball Gown Quince Dress in Taffeta and Tulle

Ball Gown Dress Quinces with Embroidery in White and Turquoise

Multi-colored Ruffled Sweet 15th Dress with One Shoulder Strap

Beaded Strapless Ball Gown Dress for Quinces with Floor-length