MySQL Forums
Forum List  »  General

Re: Extract Phone No and Email
Posted by: Rick James
Date: September 08, 2013 06:40PM

If you are using Perl or PHP, this regexp will isolate the telephone number from
...;s:9:\"telephone\";s:13:\"(09) 116 023456\";...
/;.*?telephone.*?:(.*?);/

It is possible in SQL, but it is too messy for me to contemplate. See
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
MID(), SUBSTRING_INDEX(), and maybe other functions.

Options: ReplyQuote


Subject
Written By
Posted
September 07, 2013 07:11PM
Re: Extract Phone No and Email
September 08, 2013 06:40PM
September 09, 2013 12:35AM


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.