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 vote112 views1 answer
How to make case insensitive in sql
SQL
0 vote126 views1 answer
Create table with float datatype in sql server
SQL
2 votes115 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote124 views1 answer
Sql last 3 rows
SQL
0 vote114 views1 answer
Learn sqlite dart
SQL
1 vote115 views1 answer
Clear screen command in psql
SQL
1 vote224 views2 answers
Postgres select from last 3 months
SQL
1 vote133 views3 answers
Mysql on delete set null
SQL
0 vote101 views2 answers
Android sqlite query join
SQL
3 votes112 views2 answers
Oracle apex charging debug
SQL