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

4 votes150 views1 answer
Postgres delete last row
SQL
0 vote160 views1 answer
Mysql drop vs delete
SQL
0 vote160 views1 answer
Mysql custom sort order
SQL
0 vote157 views1 answer
Select place default lat long
SQL
-1 vote157 views1 answer
Phinehas Psalm 106
SQL
6 votes162 views1 answer
Allsource oracle
SQL
0 vote157 views1 answer
How to select even id in sql
SQL
7 votes202 views2 answers
Oracle foreign key reference table
SQL
0 vote165 views1 answer
Postgresql list extensions
SQL
0 vote179 views1 answer
Mysql trigger to delete old data
SQL