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 vote156 views1 answer
Modifier une valeur sql
SQL
0 vote158 views1 answer
Oracle concat datetime
SQL
0 vote161 views1 answer
Mysql multiple group by
SQL
2 votes150 views2 answers
Sql percentage
SQL
0 vote156 views1 answer
Get the Db column names from a SqlDataReader
SQL
5 votes154 views3 answers
Bash: mysql: command not found
SQL
4 votes151 views2 answers
Error loading MySQLdb module.
SQL
0 vote136 views1 answer
Postgresql get current user name
SQL
1 vote109 views1 answer
Mysql show attributes of a table
SQL
8 votes148 views1 answer
Sql remove leading spaces
SQL