In my database table there is a text field named “summary” which stores the values as
Typical APR: 14.9% - Intro APR: 0.0% / 3 months Intro Balance Transfer: 0.0% / 14 months
Typical APR: 4.9% - Intro APR: 10.0% / 3 months Intro Balance Transfer: 0.0% / 14 months
I want to get the result as
Typical APR: 14.9%
Intro APR: 0.0% / 3 months Intro
Balance Transfer: 0.0% / 14 months
means i want there seperate strings.Can anyone give me a query for this.Also there will be some rows where some other information is written and for those fields my query should return no rates.Please help me out.