MySQL Forums
Forum List  »  Newbie

Convert string to decimal
Posted by: Chris Murphy
Date: April 12, 2012 02:39PM

I have a problem. I need to convert a portion of a string to a decimal. The string looks as follows:

'£10.50/month. 100 minutes. 500 texts. 24 months.'

I want to break out the 10.50 section and store it in a variable using php so i can allow customers to filter the results from my table by this value.

I am using mySql (phpmyadmin).

I cannot ammend the structure of the table because its provided by a third party.

How can i achieve this???

Hope I have given enough information, if not please ask.

Options: ReplyQuote


Subject
Written By
Posted
Convert string to decimal
April 12, 2012 02:39PM
April 16, 2012 12:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.