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

21 votes130 views6 answers
Change column in mysql
SQL
0 vote151 views1 answer
Test database for sql
SQL
0 vote144 views1 answer
Odd record sql query
SQL
13 votes142 views1 answer
Select count of distinct values sql
SQL
4 votes161 views2 answers
SELECT table_name FROM user_tables;
SQL
1 vote138 views2 answers
Mysql: command not found
SQL
-1 vote94 views1 answer
Oracle db list usernames
SQL
0 vote150 views1 answer
How to change mysql root password in windows 10
SQL
5 votes141 views1 answer
Sql add column after another
SQL
0 vote148 views1 answer
Trigger stock phpmyadmin output message
SQL