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 vote255 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote266 views1 answer
Hashpass
SQL
1 vote255 views1 answer
Raw query must include primary key
SQL
0 vote253 views1 answer
Java spring boot connect to sql server
SQL
1 vote222 views1 answer
Metada in sql
SQL
0 vote262 views1 answer
How to reset the database value in SQL server
SQL
4 votes223 views1 answer
Install postgres 12 on ubuntu
SQL
0 vote285 views1 answer
Create table like sql
SQL
0 vote258 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote279 views1 answer
Postgres dump sql insert
SQL