SELECT
field2,
CASE
WHEN INSTR(field2, '+82') > 0 THEN
SUBSTR(field2, INSTR(field2, '+82'))
ELSE
field2
END AS extracted_value
FROM firefox_website_02;
{350 250} 85 {8,000 .. 60δΈ} ζ―ζ μ μ§ ηζ΄»
SELECT
field2,
CASE
WHEN INSTR(field2, '+82') > 0 THEN
SUBSTR(field2, INSTR(field2, '+82'))
ELSE
field2
END AS extracted_value
FROM firefox_website_02;