| string query help [message #3159] |
Fri, 06 June 2008 01:55 |
 mysqllearner
Messages: 1
Registered: June 2008 |
Junior Member |
|
|
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.
|
|
|
Members
Search
Help
Register
Login
Home
