Skip to content Skip to sidebar Skip to footer

Mysql`s SUBSTRING_INDEX Equivalent In Postgresql

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?

Solution 1:

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

Post a Comment for "Mysql`s SUBSTRING_INDEX Equivalent In Postgresql"