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 vote254 views1 answer
Delete ids between sql
SQL
2 votes188 views1 answer
Flask sqlalchemy boolean field
SQL
4 votes190 views1 answer
Is there any command to change postgres password
SQL
2 votes187 views1 answer
Mysql last 7 days including today
SQL
0 vote180 views1 answer
Csv to sqlite python
SQL
1 vote175 views1 answer
Find difference in dates sql
SQL
1 vote198 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote184 views2 answers
Script all indexes in a database
SQL
0 vote174 views1 answer
Add column to table with default value plsql
SQL
0 vote188 views1 answer
Oracle query archive mode
SQL