Parse a substring in PostgreSQL [duplicate]

Question

Given a string, e.g.:

RT @John: Hello world! @Peter Hello!

I'd like to be able to get the part between 'RT @' and ':'. How can I accomplish this in PostgreSQL?

Michel Milezzi · Accepted Answer · 2017-11-28 17:08:35Z

0

Perhaps a simple SUBSTRING could solve your problem:

SELECT substring('RT @John: Hello world! @Peter Hello!', 'RT @(.*):');

answered Nov 28, 2017 at 17:08

Michel Milezzi

11.4k3 gold badges24 silver badges36 bronze badges

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

1 Answer 1