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

17 votes136 views1 answer
Selecting name that contain certain word in sql
SQL
11 votes126 views4 answers
Reset identity column values in sql server
SQL
0 vote104 views1 answer
Array aggre distinct postgres
SQL
1 vote103 views1 answer
Display total number of tables in mysql
SQL
0 vote177 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote117 views1 answer
Sql select column name like from multiple tables
SQL
0 vote67 views1 answer
Check if due date is less than todays date sql
SQL
16 votes107 views2 answers
Add column to all tables after first column mysql
SQL
5 votes102 views2 answers
Oracle show procedures
SQL
0 vote120 views1 answer
Look at running processes redshift
SQL