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

14 votes228 views3 answers
Alter foreign key
SQL
0 vote214 views2 answers
Postgresql get last day of month
SQL
7 votes213 views1 answer
Postgres base size
SQL
0 vote213 views1 answer
Inner join distinct
SQL
0 vote222 views1 answer
Create schema sql server
SQL
2 votes216 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
1 vote218 views2 answers
Insert sqlite
SQL
0 vote214 views1 answer
Sql menampilkan data tabel
SQL
0 vote212 views1 answer
Mysql add to value
SQL
0 vote245 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL