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 vote273 views1 answer
Mysql show queries running
SQL
13 votes260 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
0 vote277 views1 answer
How we can perform acid Operations in sql with examples
SQL
2 votes267 views1 answer
Sql missing records from another table
SQL
0 vote287 views1 answer
Copying query result to excel
SQL
21 votes278 views1 answer
SQL cheat sheet pdf
SQL
0 vote269 views1 answer
Basic structure of sql expression having clause
SQL
0 vote271 views1 answer
Mysql query with sql to get the next row
SQL
0 vote262 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote273 views2 answers
What is the default password for sql server sa
SQL