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

6 votes330 views2 answers
Stored procedure to delete data from table in mysql
SQL
4 votes305 views1 answer
Update table from another table oracle
SQL
0 vote341 views1 answer
Sql select duplicates based on two columns
SQL
0 vote321 views1 answer
Get cpu details sql
SQL
0 vote326 views1 answer
Select even number id data from table
SQL
0 vote307 views1 answer
Procedures and functions in pl/sql
SQL
0 vote321 views1 answer
Search In the Data using ObjectName
SQL
7 votes351 views6 answers
Mysql group concat
SQL
0 vote331 views1 answer
Sql character index
SQL
0 vote316 views1 answer
Uuid sqlalcomany
SQL