Line 96:
Line 96:
│ 15 rows │
│ 15 rows │
└──────────────────┘
└──────────────────┘
+
+
==== Search for a string in a list ====
+
Eg. search in the list <code>allergen_tags</code> values containing <code>fr:</code>. You have to convert the array into a string using the <code>array_to_string</code>.
+
SELECT count(code) as nb, ANY_VALUE(code), allergens_tags
+
FROM 'food.parquet'
+
where regexp_matches(array_to_string(allergens_tags, ','), 'fr:')
+
group by allergens_tags
+
order by nb desc
==== How many images where uploaded in 2024? ====
==== How many images where uploaded in 2024? ====