Mysql extract number from string

Mysql take number in string

select REGEXP_SUBSTR(name,"[0-9]+") as amount from `subscriptions`;

Source: stackoverflow.com

Mysql extract number from string

SELECT CAST(SUBSTRING(myStringWNumber, posNumStart, posNumEnd), <NUM_TYPE>) FROM table;

<NUM_TYPE>
SIGNED	  Converts value to SIGNED (a signed 64-bit integer)
UNSIGNED  Converts value to UNSIGNED (an unsigned 64-bit integer)
BINARY	  Converts value to BINARY (a binary string)
DECIMAL	  Converts value to DECIMAL. Use the optional M and D parameters 
          to specify the maximum number of digits (M) and the number of digits 
          following the decimal point (D).

Similar codes

0 vote279 views1 answer
SQL isnumeric DB2
SQL
-1 vote314 views3 answers
Error: mysql shutdown unexpectedly.
SQL
5 votes306 views2 answers
Oracle find all tables with column name
SQL
0 vote268 views1 answer
Stop psql server windows
SQL
65 votes485 views6 answers
Sql add column to table
SQL
1 vote288 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote272 views1 answer
Mysql error codeigniter
SQL
0 vote305 views1 answer
Display all node label neo4j
SQL
0 vote248 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
1 vote295 views1 answer
Oracle create as select
SQL