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 vote124 views1 answer
Connecting mySQL to STS
SQL
0 vote99 views1 answer
Show database not empty tables postgres
SQL
4 votes116 views2 answers
Float postgres
SQL
2 votes96 views1 answer
Create table with primary key
SQL
0 vote112 views1 answer
Mysql group by derived column
SQL
0 vote105 views1 answer
Get only one row in mysql
SQL
18 votes102 views4 answers
Mysql current date between two dates
SQL
3 votes144 views1 answer
Oracle nextval insert
SQL
0 vote102 views1 answer
Mysql add to number
SQL
11 votes115 views2 answers
Mysql disable safe mode
SQL