Mysql`s SUBSTRING_INDEX equivalent in postgresql [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 9 years ago.

Improve this question

I am basically trying to replicate functionality I know exists in MySQL. In MySQL it would look like:

 SUBSTRING_INDEX(p.url, 'selection=', -1)

How do I replicate this in PSQL?

Do you have a fixed number of 'selection=' delimiters in that column? — Mihai
– Mihai, Commented Dec 18, 2015 at 21:58

Mihai · Accepted Answer · 2015-12-18 22:02:40Z

4

SELECT split_part(p.url, 'selection=', 2)...

answered Dec 18, 2015 at 22:02

Mihai

26.8k8 gold badges71 silver badges87 bronze badges

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

1 Comment

expz Over a year ago

This only works for positive numbers, not negative numbers like in the OP. To select the last field, for example, use reverse(split_part(reverse(p.url), 'selection=', 1)).

Collectives™ on Stack Overflow

Mysql`s SUBSTRING_INDEX equivalent in postgresql [closed]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related