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

4 votes221 views1 answer
Oracle user tables
SQL
0 vote251 views1 answer
Count database access django
SQL
-1 vote166 views1 answer
Mysql if example
SQL
23 votes184 views6 answers
How to create table in sql
SQL
0 vote230 views1 answer
What is initial catalog in sql connection string
SQL
0 vote230 views1 answer
Mssql last day of month
SQL
6 votes187 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote177 views1 answer
Mysql server not starting in xampp in mac
SQL
0 vote213 views1 answer
SQL Where-Klausel
SQL
0 vote198 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL