Обсуждение: Simple Regex question, hoping for direct answer (no Socratic approach necessary)

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

Thanks!

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