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 vote275 views1 answer
Brisanje dupliranih konatakata
SQL
1 vote187 views1 answer
SQL date part only of datetime
SQL
3 votes188 views1 answer
Oracle undo tablespace list by user
SQL
1 vote174 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
0 vote184 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
-2 votes193 views2 answers
Union all in sql
SQL
0 vote172 views1 answer
How to search query in python3 sqlite3
SQL
0 vote162 views1 answer
Sql examples from your work
SQL
0 vote189 views1 answer
R write csv without index
SQL
0 vote254 views2 answers
Return the number of records in a single table mysql
SQL