Upholstery
SELECT `_id`, `collection`,`collection_slug`, `product_type`, `pattern_name`,`pattern_swatch`, `pattern_img`, `pattern_header`, `slug_name`, `upholstery`, `wall_covering`, `panel`, `generic_color`,
REPLACE(REPLACE(pattern_name,'ULTRALEATHER ',''), 'SUPREEN ','') AS pattern_new FROM textile_db
WHERE hide ='0'
GROUP BY `pattern_new`
ORDER BY `pattern_new`
