select concat('#',product_id,'#') from tablename where product_id like '#%XXX%#';

CREATE TABLE a AS
SELECT
        regexp_extract(`origin`,  '^.([A-Za-z0-9]*)', 1) as origin,
        regexp_extract(`dest`,  '^.([^"]*)', 1) as dest,
FROM a-gummy