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 vote250 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote224 views1 answer
Postgresql if else endif
SQL
0 vote235 views1 answer
Get last date join sql
SQL
-1 vote235 views4 answers
Restart mysql server ubuntu
SQL
0 vote253 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
1 vote238 views1 answer
Sql server today minus n
SQL
4 votes235 views3 answers
Is not null sql
SQL
0 vote230 views1 answer
Delete * from where id = 1;
SQL
0 vote229 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote240 views1 answer
To Create directory
SQL