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

9 votes118 views3 answers
Oracle undo usage by session
SQL
0 vote116 views3 answers
Get free card roblox
SQL
0 vote129 views1 answer
Sql tablo hangi sp de
SQL
-1 vote116 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote126 views2 answers
Identity syntax in sql
SQL
1 vote118 views1 answer
Psql client write to bash variable
SQL
0 vote109 views1 answer
Renommer schema sql
SQL
1 vote111 views1 answer
Delete mysql from mac
SQL
0 vote122 views2 answers
Call to undefined function mysql_query()
SQL
1 vote68 views1 answer
Ms sql how to see active job current run time
SQL