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

-1 vote377 views2 answers
Installing mysql on centos 7
SQL
1 vote358 views1 answer
Oracle activate job
SQL
0 vote350 views1 answer
Add SuperUser MySQL
SQL
7 votes371 views2 answers
Add column table pl sql
SQL
0 vote340 views1 answer
Stop psql server windows
SQL
1 vote370 views1 answer
Oracle stop
SQL
0 vote371 views1 answer
Microsoft sql server python connection
SQL
0 vote417 views1 answer
Download sql file of countries names
SQL
3 votes372 views2 answers
Enter mysql command line
SQL
0 vote365 views1 answer
Postgres type equivalent to timespan c#
SQL