字段写法: name->>'en_US'
任务:
查询name字段中,包含ring的数据
SQL模糊查询
SELECT *
FROM product_public_category
WHERE name->>'en_US' LIKE '%ring%';
SQL精准查询
SELECT *
FROM product_public_category
WHERE name->>'en_US' = 'Engagement ring';
查询name字段中,包含ring的数据
SELECT *
FROM product_public_category
WHERE name->>'en_US' LIKE '%ring%';
SELECT *
FROM product_public_category
WHERE name->>'en_US' = 'Engagement ring';