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 vote204 views1 answer
Mysql show table character set
SQL
1 vote229 views2 answers
Oracle create synonym
SQL
3 votes220 views1 answer
APEX elapsed time
SQL
6 votes210 views2 answers
Find mysql version linux
SQL
0 vote209 views2 answers
How to tun mysql on ubunto
SQL
0 vote189 views2 answers
Sql query unique
SQL
6 votes196 views1 answer
Sqlite foreign key
SQL
0 vote201 views1 answer
How to create a new db from dumb file mysql
SQL
3 votes200 views2 answers
Create schema postgres
SQL
16 votes190 views2 answers
Gremove folder from git
SQL