CONTAINS

1
SELECT product_name, price
2
FROM products
3
WHERE CONTAINS(LOWER(product_name), 'gaming');

1
SELECT
2
  email,
3
  CASE
4
    WHEN CONTAINS(email, '@gmail.com') THEN 'Gmail'
5
    WHEN CONTAINS(email, '@yahoo.com') THEN 'Yahoo'
6
    WHEN CONTAINS(email, '@outlook.com') THEN 'Outlook'
7
    ELSE 'Other'
8
  END as email_provider
9
FROM users;

1
SELECT
2
  phone,
3
  CASE
4
    WHEN CONTAINS(phone, '+62') THEN 'Indonesian'
5
    WHEN CONTAINS(phone, '+1') THEN 'US'
6
    ELSE 'Unknown'
7
  END as country
8
FROM contacts;