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

0 vote241 views1 answer
Transaction and commit trong sql server
SQL
4 votes196 views1 answer
What are the data types in sql
SQL
2 votes211 views1 answer
Compare date in sql
SQL
11 votes203 views1 answer
Oracle view ddl
SQL
3 votes239 views3 answers
Create table in SQL Server
SQL
0 vote234 views2 answers
Jsonb
SQL
0 vote238 views1 answer
Mssql last day of month
SQL
3 votes196 views2 answers
Postgresql remove not null constraint
SQL
13 votes204 views2 answers
Get date from now() mysql
SQL
0 vote195 views1 answer
Sql view index
SQL