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 vote349 views1 answer
Mysql 3 months ago
SQL
0 vote418 views1 answer
What is common table expression in sql
SQL
1 vote353 views1 answer
Dropping a constraint in ms sql
SQL
0 vote378 views1 answer
Alternative for LIMIT sql
SQL
0 vote332 views1 answer
USING THE NOT CONDITION IN SQL
SQL
17 votes320 views6 answers
Sql select distinct
SQL
8 votes327 views2 answers
Safe update mode in mysql
SQL
0 vote399 views1 answer
Postgres extract number from string
SQL
0 vote343 views1 answer
R write csv without index
SQL
0 vote627 views1 answer
How to connect .sql data set to powerbi
SQL