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 vote188 views4 answers
User defined function sql
SQL
9 votes174 views3 answers
Show table columns mysql command line
SQL
1 vote227 views2 answers
Sql select only row with the max date
SQL
0 vote193 views1 answer
Max mysql
SQL
0 vote190 views1 answer
Sql missing values
SQL
4 votes188 views3 answers
Employee name starting with in sql
SQL
10 votes135 views2 answers
Django mysql
SQL
0 vote192 views1 answer
How we can perform acid Operations in sql with examples
SQL
5 votes179 views1 answer
Mysql add user with all privileges
SQL
1 vote199 views1 answer
Oracle create_program
SQL