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

2 votes351 views2 answers
Python escape string for sql
SQL
0 vote285 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote285 views1 answer
Retornar apenas o ano mysql date
SQL
-1 vote284 views3 answers
Psql get last rows
SQL
3 votes297 views1 answer
Query less than datetime sql
SQL
0 vote329 views1 answer
Mysql average from two table
SQL
2 votes251 views1 answer
Latest record in sql
SQL
1 vote298 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote294 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
1 vote304 views2 answers
Oracle list service names
SQL