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 vote294 views1 answer
Oracle webcenter content search enginer
SQL
5 votes279 views1 answer
Oracle nls instance
SQL
1 vote275 views1 answer
Drush sql-dump
SQL
6 votes283 views2 answers
If not exists insert sql
SQL
0 vote338 views1 answer
Postgres extract number from string
SQL
0 vote265 views1 answer
Sql row number in result set
SQL
0 vote274 views1 answer
Query archive mode
SQL
2 votes276 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote280 views1 answer
Kill a pid redshift
SQL
1 vote263 views1 answer
Truncate left characters mysql
SQL