SELECT
field2,
CASE
WHEN INSTR(field2, '+82') > 0 THEN
SUBSTR(field2, INSTR(field2, '+82'))
ELSE
field2
END AS extracted_value
FROM firefox_website_02;
{200} 1,500 JINU {8,000 / 1万 .. 1百万 × 毎6年}
SELECT
field2,
CASE
WHEN INSTR(field2, '+82') > 0 THEN
SUBSTR(field2, INSTR(field2, '+82'))
ELSE
field2
END AS extracted_value
FROM firefox_website_02;