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 vote164 views1 answer
Window function to forward fill
SQL
2 votes162 views3 answers
Replace null in sql
SQL
3 votes157 views1 answer
Postgresql db owner change
SQL
-1 vote172 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
3 votes156 views1 answer
Make a field auto_increment mysql
SQL
0 vote196 views1 answer
Tsql cte in a transaction
SQL
0 vote147 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote163 views1 answer
Psql check if sql script is valid
SQL
3 votes168 views1 answer
Select table column in sql
SQL
0 vote153 views1 answer
Drop tables from local database postgres pgadmin
SQL