Products with Norwegian Characters (æøå)

Custom SQL query (hide)

SELECT id, name,
       '{"href": "/images/' || id || '.jpg", "img_src": "/images/' || id || '.jpg"}' as image,
       language
FROM products
WHERE name LIKE '%æ%' OR name LIKE '%ø%' OR name LIKE '%å%'
   OR name LIKE '%Æ%' OR name LIKE '%Ø%' OR name LIKE '%Å%'
ORDER BY name

Edit SQL