# string query help

**URL:** <https://forums.percona.com/t/string-query-help/790>\
**Category:** Other MySQL® Questions\
**Created:** [June 6, 2008, 12:25am UTC](https://forums.percona.com/t/string-query-help/790 "2008-06-06T00:25:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mysqllearner](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@mysqllearner](https://forums.percona.com/u/mysqllearner)\
**Post date:** [June 6, 2008, 12:25am UTC](https://forums.percona.com/t/string-query-help/790/1 "2008-06-06T00:25:18Z")

</div>

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.