PREFIX

1
SELECT product_code, product_name
2
FROM products
3
WHERE PREFIX(product_code, 'ELC');

1
SELECT
2
  phone,
3
  CASE
4
    WHEN PREFIX(phone, '021') THEN 'Jakarta'
5
    WHEN PREFIX(phone, '022') THEN 'Bandung'
6
    WHEN PREFIX(phone, '031') THEN 'Surabaya'
7
    WHEN PREFIX(phone, '08') THEN 'Mobile'
8
    ELSE 'Other'
9
  END as phone_type
10
FROM contacts;

1
SELECT timestamp, message
2
FROM logs
3
WHERE PREFIX(message, 'ERROR:') OR PREFIX(message, 'FATAL:');