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 vote352 views1 answer
Search starting with mysql
SQL
0 vote337 views1 answer
Where case insensitive like mysql
SQL
-1 vote342 views1 answer
How to check table exists or not in postgresql
SQL
0 vote335 views1 answer
T-sql check if data exists
SQL
8 votes304 views1 answer
Similarities between ddl and dml
SQL
0 vote346 views2 answers
Azure sql-datenbank
SQL
0 vote301 views1 answer
Kannst du deine finger trainieren
SQL
0 vote346 views1 answer
Codigo crear tablas sql server
SQL
0 vote353 views1 answer
Postgresql combine values in one field
SQL
1 vote305 views1 answer
Postgres division by zero
SQL