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 vote147 views1 answer
Oracle sql date summer time
SQL
0 vote153 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
6 votes135 views1 answer
Oracle trigger after logon on database
SQL
0 vote144 views1 answer
Sql find all different values in column
SQL
16 votes162 views5 answers
Select last row in sql
SQL
0 vote130 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
12 votes139 views4 answers
How to take database dump in postgresql
SQL
-1 vote158 views1 answer
Capitole toulouse
SQL
0 vote136 views1 answer
Oracle query archivemode
SQL
1 vote146 views1 answer
Raw query must include primary key
SQL