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?
Asked
Active
Viewed 2,507 times
2
-
And your question is...? – Marc B Dec 18 '15 at 21:55
-
How do I do the same thing PSQL... – Spencer Dec 18 '15 at 21:55
-
Do you have a fixed number of 'selection=' delimiters in that column? – Mihai Dec 18 '15 at 21:58
-
there will be either 1 or 0. – Spencer Dec 18 '15 at 22:01
1 Answers
4
SELECT split_part(p.url, 'selection=', 2)...
Mihai
- 26,325
- 7
- 66
- 81
-
2This 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))`. – expz Sep 22 '16 at 22:01