Delete from postgresql db according to matching regex

Question

Does anyone know how to remove a record from DB according to the regexp pattern? So now I have found all the required data for removal like so:

SELECT code, regexp_matches(code, '^(?!([EHIVPZ])).*') code
FROM "sku";

but cannot figure out how to remove them properly?

Gordon Linoff · Accepted Answer · 2020-12-02 12:05:50Z

3

Why not just put the pattern into a delete statement?

delete from sku
    where code ~ '^(?!([EHIVPZ])).*')

answered Dec 2, 2020 at 12:05

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

oh ~ of course, I completely forgot this. Thank you @Gordon Linoff