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 vote310 views1 answer
Mysql root permission denied lost
SQL
0 vote312 views2 answers
Update information in a mysql column
SQL
8 votes290 views3 answers
Alter table auto_increment
SQL
0 vote290 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
1 vote284 views1 answer
How to print longest name in sql
SQL
4 votes288 views1 answer
Oracle change nls_date_format permanently
SQL
13 votes308 views4 answers
Command line mysql import
SQL
0 vote347 views1 answer
For row in sql database python loop
SQL
0 vote278 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote298 views3 answers
Group_concat sql server
SQL