Find the string after a specific substring in mysql

Question

I want to retrieve the last part of a large string in mysql after occurence of a particular substring. Please advice about how to do that.

For e.g. the main string contains "New Delhi is capitalof India". "Berlin is capitalof Germany".

I need to retrieve only India and Germany. I want know how to retrieve the data occuring after the specific substring like 'capitalof'.

I need to do this in mysql.

PM 77-1 · Accepted Answer · 2015-06-16 05:28:52Z

12

select
substring_index(title,'capitalof',-1)
from table1

PM 77-1

13.4k21 gold badges73 silver badges118 bronze badges

answered Jun 16, 2015 at 5:25

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

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

1 Answer 1