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 vote329 views2 answers
Insert into
SQL
0 vote383 views1 answer
Sql find gaps in date ranges
SQL
0 vote345 views1 answer
Convert int to varchar sql
SQL
0 vote358 views1 answer
Kill slow queries mysql
SQL
3 votes338 views1 answer
Sql server version query
SQL
2 votes327 views1 answer
Check isolation level in mysql
SQL
0 vote407 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote366 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote378 views1 answer
Sql values that contains certain multiple ids
SQL
7 votes359 views1 answer
Query postgres delete duplicates
SQL