Search
SELECT _id, hide, SSProductIDNum, style_name, style_group,style_slug, product_name, parent_category,category, slug_name, category_slug,hero_img
FROM products WHERE hide = 0
AND (`SSProductIDNum` LIKE '%101%' OR `style_name` LIKE '%101%'
AND hero_img <> ''
OR `product_name` LIKE '%101%'
OR `category` LIKE '%101%'
OR `style_group` LIKE '%101%')
ORDER BY style_name ASC, product_name ASC
RESULTS FOR: "101"
SELECT _id, hide, SSProductIDNum, style_name, style_group,style_slug, product_name, parent_category,category, slug_name, category_slug,hero_img
FROM products WHERE hide = 0
AND (`SSProductIDNum` LIKE '%full%' OR `style_name` LIKE '%full%'
AND hero_img <> ''
OR `product_name` LIKE '%full%'
OR `category` LIKE '%full%'
OR `style_group` LIKE '%full%')
ORDER BY style_name ASC, product_name ASC
RESULTS FOR: "full"
SELECT _id, hide, SSProductIDNum, style_name, style_group,style_slug, product_name, parent_category,category, slug_name, category_slug,hero_img
FROM products WHERE hide = 0
AND (`SSProductIDNum` LIKE '%size%' OR `style_name` LIKE '%size%'
AND hero_img <> ''
OR `product_name` LIKE '%size%'
OR `category` LIKE '%size%'
OR `style_group` LIKE '%size%')
ORDER BY style_name ASC, product_name ASC
RESULTS FOR: "size"
SELECT _id, hide, SSProductIDNum, style_name, style_group,style_slug, product_name, parent_category,category, slug_name, category_slug,hero_img
FROM products WHERE hide = 0
AND (`SSProductIDNum` LIKE '%sofa%' OR `style_name` LIKE '%sofa%'
AND hero_img <> ''
OR `product_name` LIKE '%sofa%'
OR `category` LIKE '%sofa%'
OR `style_group` LIKE '%sofa%')
ORDER BY style_name ASC, product_name ASC
