35.Shopper - 浏览和搜索产品

通过上一节，查看没有所谓的“cup”类别，Don决定搜索具有子串“cup”的产品名称。

你知道......

研究品牌产品时,44%的在线消费者首先执行一个搜索?

SELECT 
    productId, name
    FROM product
    WHERE LOWER(name) LIKE "%cup%"

结果：

{
  "results": [
    {
      "name": "Fotodiox Thermo Lens Cup with Stainless Steel Insulated Tumbler, Coffee and Refreshment Mug, 1:1 Nikon Lens imitation Thermo Cup (Modeling 24-70mm F2.8G Lens), 16oz",
      "productId": "product100"
    },
    {
      "name": "Cuisinart DCC-1200 Brew Central 12-Cup Programmable Coffeemaker, Black/Brushed Metal",
      "productId": "product30"
    },
    {
      "name": "Aroma ARC-914SBD 4-Cup (Uncooked) 8-Cup (Cooked) Digital Rice Cooker and Food Steamer",
      "productId": "product33"
    },
    {
      "name": "Mr. Coffee BVMC-SJX33GT 12-Cup Programmable Coffeemaker, Chrome",
      "productId": "product35"
    },
    {
      "name": "Black & Decker JE2200B 400-Watt Fruit and Vegetable Juice Extractor with Custom Juice Cup",
      "productId": "product37"
    },
    {
      "name": "Mr. Coffee DRX5 4-Cup Programmable Coffeemaker, Black",
      "productId": "product41"
    },
    {
      "name": "Pyrex Prepware 2-Cup Measuring Cup, Clear with Red Measurements",
      "productId": "product50"
    },
    {
      "name": "Sjoberg Nordic Plus Cupboard",
      "productId": "product575"
    },
    {
      "name": "Chicago Metallic Baking Essentials Silicone Baking Cups, Set of 12",
      "productId": "product68"
    },
    {
      "name": "Marina Floating Thermometer with Suction Cup",
      "productId": "product702"
    },
    {
      "name": "Wilton 4-Tier Stacked Cupcake and Dessert Tower",
      "productId": "product75"
    },
    {
      "name": "24-105mm Travel Coffee Mug / Cup / Thermos with Drinking Lid & Quality Stainless Steel Interior",
      "productId": "product82"
    },
    {
      "name": "Hamilton Beach 40515 42-Cup Coffee Urn, Silver",
      "productId": "product91"
    },
    {
      "name": "Camera Lens 1:1 Ef 70-200 F2.8 Is Coffee Cup Model Mug Latest Generation",
      "productId": "product93"
    }
  ]
}