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 vote323 views1 answer
How to make a select in sql
SQL
0 vote91 views1 answer
SQL Server format datetime
SQL
0 vote105 views1 answer
Db format in quotation
SQL
0 vote98 views2 answers
Mysql select date from datetime
SQL
3 votes102 views2 answers
Brew start mysql
SQL
0 vote107 views1 answer
Sub query in linq
SQL
12 votes117 views6 answers
Change mysql root password
SQL
0 vote98 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote110 views8 answers
Convert sql query to linq online
SQL
7 votes105 views1 answer
Connect mysql docker
SQL