Mysql regular expression on select statement

[rbncha]

Hi,

I have found mysql doesn't support regular expression on select statement for replace/find/trim/substring purposes. So there's no way to extract the phone number from this query.

SELECT replace('Call me at 0123456789 asap', '[^0-9]*', '');

I could know is only this which returns true/false. And unfortunately, this doesn't do what I exactly want to do.

SELECT 'Call me at 0123456789 asap' REGEXP '[0-9]*';

Let me know if there's already a solution.