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 vote239 views1 answer
Oracle sql alter view add column
SQL
10 votes242 views1 answer
Oracle dependencies table
SQL
0 vote285 views1 answer
Plpgsql create function
SQL
0 vote223 views1 answer
Find largest table in mysql database
SQL
0 vote242 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote240 views1 answer
Set classpath for mysql-connector.jar
SQL
7 votes243 views3 answers
Python and mysql connectivity
SQL
0 vote233 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote234 views1 answer
Oracle step procedure
SQL
0 vote233 views2 answers
How to start postgresql laravel
SQL