Mysql regular expression on select statement
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.
I could know is only this which returns true/false. And unfortunately, this doesn't do what I exactly want to do.
SELECT replace('Call me at 0123456789 asap', '[^0-9]*', '');
Let me know if there's already a solution.
SELECT 'Call me at 0123456789 asap' REGEXP '[0-9]*';