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

1 vote345 views1 answer
Oracle create program if no exists
SQL
0 vote400 views1 answer
T-sql delete view if exists
SQL
0 vote393 views1 answer
How to run mysql on terminal mac
SQL
0 vote379 views1 answer
Database db connection string format
SQL
1 vote414 views3 answers
How to reset id column in sql server
SQL
0 vote349 views1 answer
Select top 3 sql
SQL
0 vote394 views4 answers
Convert databse to achieve log mode oracle
SQL
2 votes375 views1 answer
Mysql application.properties spring boot
SQL
6 votes348 views2 answers
WHERE value IS sql
SQL
0 vote362 views1 answer
Add unique constraint sql server multiple columns
SQL