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 vote194 views2 answers
Mysql update two tables at once
SQL
-2 votes202 views1 answer
Create trigger syntax
SQL
0 vote199 views1 answer
Mysql events not work
SQL
0 vote206 views1 answer
How to locate pg_hba.conf file
SQL
0 vote222 views1 answer
Finding leap year in sql
SQL
0 vote305 views1 answer
Oracle db get table sizes
SQL
2 votes244 views1 answer
Mysql shell insert into
SQL
2 votes215 views1 answer
Merge firstname and lastname in sql oracle
SQL
1 vote185 views2 answers
Mysql order by date asc null last
SQL
10 votes188 views1 answer
Oracle view dependencies
SQL