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 vote120 views1 answer
PLS-00225 type
SQL
1 vote138 views1 answer
How to select multiple columns from different tables in mysql
SQL
2 votes119 views1 answer
Oracle sql concatenate results into string
SQL
0 vote123 views1 answer
List all permissions on a table in postgres
SQL
3 votes130 views1 answer
Create a table with an id in mysql
SQL
0 vote137 views1 answer
Query only first letter string
SQL
0 vote140 views1 answer
Check for directory in bash
SQL
3 votes150 views2 answers
Synonym oracle
SQL
1 vote90 views1 answer
Oracle boolean to varchar
SQL
0 vote187 views1 answer
Scheduled mysql database backup in linux
SQL