STRPOS

1
SELECT
2
  text,
3
  STRPOS(text, 'SQL') as sql_position
4
FROM (
5
  SELECT 'Belajar SQL di DuckDB' as text UNION ALL
6
  SELECT 'Python dan Data Science' UNION ALL
7
  SELECT 'SQL untuk Analisis'
8
);

1
SELECT *
2
FROM products
3
WHERE STRPOS(LOWER(product_name), 'wireless') > 0;

1
SELECT
2
  url,
3
  CASE
4
    WHEN STRPOS(url, '/api/') > 0 THEN 'API Call'
5
    WHEN STRPOS(url, '/admin/') > 0 THEN 'Admin Page'
6
    ELSE 'Public Page'
7
  END as page_type
8
FROM access_logs;