firefox_website_02.pl extraction SQLite – PHONE

SELECT
    field2,
    CASE
        WHEN INSTR(field2, '+82') > 0 THEN
            SUBSTR(field2, INSTR(field2, '+82'))
        ELSE
            field2
    END AS extracted_value
FROM firefox_website_02;

Leave a Reply

Your email address will not be published. Required fields are marked *