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

6 votes297 views2 answers
Difference between join vs union
SQL
0 vote294 views1 answer
Call object contructor and call methods of object
SQL
0 vote270 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote259 views1 answer
Get duplicate entry sql
SQL
2 votes244 views1 answer
Latest record in sql
SQL
1 vote282 views1 answer
Oracle schema size
SQL
0 vote279 views1 answer
Call function sql oracle with output put line
SQL
0 vote260 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote270 views1 answer
Sql grant select only
SQL
1 vote278 views1 answer
Postgresql transaction discard all
SQL