DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
mysql take number in string
select
REGEXP_SUBSTR
(
name
,
"[0-9]+"
)
as
amount
from
`
subscriptions
`
;
Source by stackoverflow.com #
PREVIOUS
NEXT
Tagged:
#mysql
#number
#string
ADD COMMENT
Topic
COMMENT
Name
9+7 =
Submit