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 vote179 views1 answer
Oracle check table space
SQL
0 vote165 views1 answer
Sql with example
SQL
18 votes168 views4 answers
Uninstall mysql ubuntu 18.04
SQL
2 votes167 views1 answer
Wait delay in sql server
SQL
0 vote168 views1 answer
Vowels in sql
SQL
0 vote166 views2 answers
Sqlite unique
SQL
24 votes179 views4 answers
Postgres delete database
SQL
0 vote169 views1 answer
Back up stored procedures mysql
SQL
8 votes183 views1 answer
Oracle search stored procedures for text
SQL
2 votes178 views1 answer
Q operator in oracle
SQL