Regex patterns I keep reaching for.Regex patterns I keep reaching for.

Use this pattern to extract only the course ID from meta keys like course_123_access_from:

(?<=course_)[0-9]+(?=_access_from)

Use this one in SQL to pull out the first number found inside a string:

REGEXP_SUBSTR(%1$s, '[0-9]+')