Announcement

Announcement Module
Collapse
No announcement yet.

string query help

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • string query help

    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.
Working...
X