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 vote130 views1 answer
Excel export from sql using python
SQL
0 vote128 views1 answer
Mysql select row with min date
SQL
0 vote129 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote126 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote130 views1 answer
Rename constraint postgresql
SQL
2 votes131 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
2 votes113 views1 answer
Wait delay in sql server
SQL
2 votes115 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote166 views1 answer
Ms sql print more than 1 variable
SQL
0 vote125 views4 answers
Restart MySQL
SQL