Samila Mohd Zain Samila Mohd Zain - 3 months ago 6x
SQL Question

To get partial character

jitter (Index: 1200) to ;
jitter (Index: 900) to 223.28.0.xx ;
jitter (Index: 700) to ;

How do I get partial character that starts from '223 until end' ?
Currently, I am using the substring (resource_name,24), but my solution is not suitable as it unable to fulfill all new requirements.


Use substring with position(substring in string) It tells the position of the 223 in your string. More info in PostgresSQL Documentation

Like this:

SELECT substring(resource_name, poisition('223' in resource_name))