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 vote210 views1 answer
Limit offset order by mysql
SQL
0 vote196 views1 answer
Select year from dual oracle
SQL
0 vote207 views1 answer
Postgresql port 5432 not open
SQL
-1 vote198 views1 answer
Add bool column in sql
SQL
0 vote192 views1 answer
Oracle create job if not exists
SQL
8 votes224 views1 answer
See all users mysql
SQL
1 vote195 views2 answers
Sql drop multiple columns if exists
SQL
0 vote191 views1 answer
Sql select inside select sub query
SQL
0 vote237 views1 answer
Get initials name in sql
SQL
0 vote234 views1 answer
How to find unique element in sql
SQL