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 vote439 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote363 views1 answer
Declarative base sqlalchemy
SQL
0 vote425 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote366 views1 answer
Sql change primary key to composite key
SQL
3 votes360 views1 answer
Force using index oracle
SQL
0 vote314 views1 answer
Create bakupd database sqlserver
SQL
0 vote352 views2 answers
Sql server select first day of previous year
SQL
0 vote334 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote375 views1 answer
Select count concat string sql server
SQL
-1 vote326 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL