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 vote152 views1 answer
Sql waitfor
SQL
0 vote198 views1 answer
Postgres rename database
SQL
5 votes129 views2 answers
Sql conn
SQL
1 vote145 views4 answers
Mysqldump 1 table only
SQL
1 vote115 views1 answer
Pentaho + pasar de excel a sql
SQL
0 vote125 views1 answer
The local psql command could not be located
SQL
3 votes149 views1 answer
Select table column in sql
SQL
1 vote143 views1 answer
Mysql add fields
SQL
0 vote168 views1 answer
Find wordpress version in database
SQL
0 vote132 views1 answer
Sql delete where x or y or z
SQL