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 vote263 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote263 views1 answer
Oracle exchange subpartition
SQL
0 vote264 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote255 views1 answer
Renommer schema sql
SQL
31 votes269 views3 answers
SQL Server change column data type
SQL
0 vote285 views1 answer
Example database query
SQL
3 votes263 views1 answer
Force using index plsql
SQL
0 vote258 views1 answer
Sql server cannot create database diagram
SQL
0 vote260 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote294 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL