CODE EXAMPLE FOR SQL

mysql take number in string

select REGEXP_SUBSTR(name,"[0-9]+") as amount from `subscriptions`;