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

9 votes290 views2 answers
Default number in sql
SQL
0 vote318 views1 answer
Case insensitive sql
SQL
0 vote348 views1 answer
Declare or use variable in snowflake
SQL
0 vote347 views1 answer
Pgadmin save data greyed out
SQL
1 vote347 views1 answer
How to put value in variable mysql
SQL
0 vote314 views1 answer
Mariadb errno 121
SQL
13 votes325 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote315 views1 answer
Multiple left join mysql
SQL
0 vote320 views1 answer
Systems sql
SQL
0 vote311 views1 answer
Postgres enumerated type
SQL