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

8 votes311 views10 answers
Sql
SQL
3 votes336 views1 answer
How to add unique constraint in mysql table
SQL
1 vote302 views1 answer
Pl sql ptint
SQL
0 vote291 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote346 views1 answer
For row in sql database python loop
SQL
0 vote336 views1 answer
Check if mysql db is used
SQL
1 vote318 views1 answer
Oracle sequence last_number
SQL
0 vote335 views1 answer
Implode in sql query
SQL
0 vote305 views1 answer
Cast float mysql
SQL
0 vote298 views1 answer
Sauvegarde complète my sql
SQL