Extract phone with the format ###-###-#### from the cr_data text field with id 1234567
SELECT
REGEXP_SUBSTR(cr_data, '\\d{3}-\\d{3}-\\d{4}') AS extracted_phone
FROM
b_log
WHERE
b_id = 1234567;
- Public
- ·
- Thu, 18 Jan 2024 13:21:45 GMT