SUFFIX

1
SELECT filename, size_kb
2
FROM files
3
WHERE SUFFIX(LOWER(filename), '.pdf');

1
SELECT
2
  email,
3
  CASE
4
    WHEN SUFFIX(email, '.com') THEN 'Commercial'
5
    WHEN SUFFIX(email, '.co.id') THEN 'Indonesian Company'
6
    WHEN SUFFIX(email, '.edu') THEN 'Educational'
7
    WHEN SUFFIX(email, '.gov') THEN 'Government'
8
    ELSE 'Other'
9
  END as domain_type
10
FROM users;

1
SELECT
2
  order_number,
3
  SUFFIX(order_number, '-RUSH') as is_rush_order
4
FROM orders;