Re: Simple Regex question, hoping for direct answer (no Socratic approach necessary)

Postgres User wrote:
> I'm new to Regex in Postgres. Can someone give me a quick pointer on
> how I'd SELECT the substring between '<name>' and '</name>' in
> a field?
>
> Sample field data:
> address city here <name>Rogers, Jim</name> zip code place
>
> and I'd like the SELECT to return only:
> Rogers, Jim

SELECT regexp_replace(
'Sing along with <name>Rogers, Jim</name>',
'.*<name>(.*?)</name>.*',
E'\\1');

regexp_replace
----------------
Rogers, Jim
(1 row)

Yours,
Laurenz Albe