How to get only Digits from rows in mariadb?

42 views Asked by At
MariaDB [cms]> select userLabel from cnf_network_function where nfType='du' order by id desc limit 1\G
*************************** 1. row ***************************
userLabel: mvnr-cv11|me-mtcil1|123005011

===

userLabel: mvnr-cv11|me-mtcil1|123005011

I need only number from above column is it possible?

like

select userLabel from cnf_network_function  ........;

output should be

select userLabel from cnf_network_function  ........;
*************************** 1. row ***************************
userLabel:123005011

expectation was --

select userLabel from cnf_network_function  ........;
*************************** 1. row ***************************
userLabel:123005011
0

There are 0 answers